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
Solution provided by Atlassian support that worked for me. AQL should read as:
object HAVING inboundReferences(objectType = User AND "Name" = ${User})
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.