-
Type:
Bug
-
Resolution: Timed out
-
Priority:
Low
-
Component/s: Assets - Import - Rearchitecture
-
1
-
Severity 3 - Minor
Issue Summary
Object references can't be imported with the AQL that worked before migrating the new architecture during the Assets external import.
Steps to Reproduce
- Create an object type named "Company"
- Create two objects, "Atlassian" and "Trello", under the object type "Company"
- Create an object type named "Employee" with the following attributes:
- Name: Label attribute
- Email address: Unique attribute
- Company: Referencing objects under the object type "Company", and allowing multiple values
- Department: Select list with options such as "Support", "Sales", and allowing multiple values
- Create an object "test-user" under the object type "Company" with the Email address "test@atlassian.com"
- Create a CSV below:
Name, Email address, Company, Department test-user, test@atlassian.com, Atlassian, Support test-user, test@atlassian.com, Trello, Sales
- Import the above CSV data into the object type "Employee"
- "Email address" attribute is used as an identifier
- The reference mapping for "Company" in the attribute mapping setting is
objecttype = Company and Label = ${Company}
Expected Results
The object "test-user" is updated with the following values:
- Name: test-user
- Email address: test@atlassian.com
- Company: Atlassian. Trello (referencing the objects)
- Department: Support, Sales
Actual Results
The object "test-user" is updated with the following values:
- Name: test-user
- Email address: test@atlassian.com
- Company: EMPTY
- Department: Support, Sales
Workaround
Update the AQL used for the reference mapping for "Company"
objecttype = Company and Label in (${Company${0}})
- mentioned in
-
Page Loading...