Object references can't be imported with the AQL that worked before migrating the new architecture

XMLWordPrintable

    • 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

      1. Create an object type named "Company"
      2. Create two objects, "Atlassian" and "Trello", under the object type "Company"
      3. 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
      4. Create an object "test-user" under the object type "Company" with the Email address "test@atlassian.com"
      5. Create a CSV below:
        Name, Email address, Company, Department
        test-user, test@atlassian.com, Atlassian, Support
        test-user, test@atlassian.com, Trello, Sales
        
      1. 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}})
      

              Assignee:
              Nishchal Prakash
              Reporter:
              K. Tajima
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: