Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to import an attribute that would look at a different object type's attribute?

Chris Cotton March 16, 2023 edited

I'm looking to have a location attribute that points to a Location Object Type for a physical asset to point to a user's Object Type for their location and then set the location for the physical asset Object.

That sounds confusing to me even typing it out. 

I have Jane as an employee. She works in the London location. Jane's workstation name is LDN23. I have 3 Object Types: Employee, Location, and Workstation. I have two CSV files that I'm importing from. 1 is an AD export with employee's info including location and 2 is workstation info. CSV 2 knows that LDN23 is assigned to Jane but does not know the location. I import CSV 1 first and Jane's location is set in her object. I would like to set a mapping for CSV 2 that when it sees Jane is assigned LDN23, it will look at Jane's Object and look at the Location attribute that is set for her and automatically update LDN23 to the London Location Object.

I've tried multiple variations of object having outR or inR AQL commands and I'm to the point of almost being done with having the config built but this is the one item I need to conquer first. I've tried dot notation for referencing objects but have not had any success. 
I have attempted what is listed in this documentation but it seems to be more for an Object Type that is referenced in the import CSV. Importing Asset object types with attributes referencing existing objects | Jira | Atlassian Documentation

2 answers

1 accepted

1 vote
Answer accepted
Chris Cotton April 10, 2023

Solution provided by Atlassian support that worked for me. AQL should read as: 

object HAVING inboundReferences(objectType = User AND "Name" = ${User})

0 votes
Riley Venable
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 16, 2023

You can set a mapping for CSV 2 that when it sees Jane is assigned LDN23, it will look at Jane's Object and look at the Location attribute that is set for her and automatically update LDN23 to the London Location Object by using the Edit attributes mapping option in the Import tab of the Object schema. You can select a Data source field and a Destination attribute to map with the Data Locator, and optionally modify the default settings for this attribute mapping. 

Chris Cotton March 17, 2023 edited

Thank you for the reply, @Riley Venable . What you are describing is exactly what I want. I feel like I've tried the how portion of your answer with no success or I'm wildly off base on how I should be doing it. The latter is most likely accurate as I've had many situations in Jira that a few tries to click but this one is refusing to compute in my brain. My Data source field is my user. My Destination Field is my Location object because that's the field I want updated. I understand that it's pointing to info in the CSV that won't match with the field. I have attempted this with my User data source field pointing to my Assigned User Destination attribute and worked with the AQL in every way that I can think of from documentation. 

1.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events