-
Bug
-
Resolution: Won't Fix
-
Low
-
None
-
1
-
Minor
-
Issue Summary
In an import in Insight, you can import multiple referenced objects into an attribute. You can do this using a placeholder in the IQL like "Label IN (${Locator${0}})" where Locator is replaced by the name of the Locator.
If your Locator value has multiple values (e.g. in a CSV file that column contains "Value A || Value B || Value C") you can select just the nth value using "Label IN (${Locator${n}})".
However, if one of your rows contains only one value, using "Label IN (${Locator${1}})" won't return any value (where it should return the same as "Label IN (${Locator${0}})".
See https://support.atlassian.com/jira-service-management-cloud/docs/create-attributes-and-references-from-your-data/ and
https://support.atlassian.com/jira-service-management-cloud/docs/use-placeholders-to-replace-information-depending-on-context/ for more information.
Steps to Reproduce
- Create a schema with two object types, "Team" and "Member". Add an attribute to "Team" that references the "Member" object. Create three Member objects (MemberA, MemberB, MemberC)
- Create an import source with the CSV file attached
- Map the "Team" locator to the Name attribute
- Map the "Member" locator to the Member attribute
- Add the IQL "Label IN (${Member${1}})"
- Run the import
Expected Results
The first member in each row is added as an attribute value.
Actual Results
The first member is added from the row with multiple values.
The row with a single value has nothing in the attribute.
Workaround
Add dummy value(s) after the ||.