Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Why do all Objects get removed by IQL filter when Importing from other Schema

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. 

1 answer

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.

If thats the case I would suggest this is a bug with the software, if the IQL works in the search context but not in the Filter of the object mapping /Import then it sounds like Insight (no atlassian) need to pick this up 

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.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events