I am running an import in insight from one Schema to another as part of a re-design / re-structure.
The old schema object type has a Select type attribute, cardinality is set to unlimited.
I am wanting to filter on this attribute to return only the records that have an entry of 'Managed'
When setting up the Object Type Mapping, I populate the 'Filter data source by IQL' with:
Services LIKE "Managed"
When I synchronise the mapping, there are 749 entries in the source, but 749 entries are removed by the IQL filter.
Running the same IQL filter directly in Insight returns the expected 69 records.
Insight Import's Filter Objects by IQL feature struggles with IQL filters that have attributes that reference IQL objects, and I guess, based on the "Unknown Values" configuration, may struggle with Select fields too.
I recommend creating a plain text attribute, mapping to that as well, and pointing the IQL filter to that plain text attribute. Just drop this attribute when the import is done.
Yes, it's a bug. Please raise it with Atlassian, they can only work to fix it if they know about it. Make sure to provide steps to replicate the bug: I suggest confirming the bug in a separate Object Schema with two object types and providing Atlassian with the schema JSON and the import CSV file that replicates the bug.
As a workaround, this temporary text attribute will let you complete the import.
Hello folks! To the member of organizations who are still running their Atlassian applications on the server, we are on the side of the bridge, and if we need to sail the boat with confidence either...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events