Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Data Center

Architect your Atlassian Data Center Application (Jira, Confluence, Bitbucket) in Azure

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...

476 views 0 11
Read article

Community Events

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

Events near you