IQL Filtering for JIRA Service Desk Edited



I have a multi-customer Service Desk Project, which uses Insight to provide various bits of information, all displayed via a set of cascading Insight Custom Fields.  I would like to be able to filter the customer fields using IQL.


I have a value against each Insight object called "Customer" which is equal to the value of Organization in JSD.  So my simplistic IQL would be


"Customer" = Organization


But this doesn't work - any ideas?






1 answer

Hi Richard,

This is because there aren't any placeholders available in the IQL for the custom fields. According to your IQL, the Customer has to have the Label Organization, so it's not dynamically picking up the name for the Organization selected.

What can be done is to restrict a custom field to User Related Objects, it fetches on User type, Group type and Email default type attributes.

In that use case, you would have one field where you chose the organisation (Insight object, custom field), which you should be restricting to User Related Objects on the current user.

Then the other fields would be Insight reference fields, where you can select the objects references from the organisation selected in the first field mentioned.

Let me know what you think about the above approach.

You can read more about our custom fields at where we have links to our different custom fields.

Best Regards

Hi - the "Oraganization" isn't a custom field really = it's a built-in JSD field.


The User Related objects is a potential option but as you've said would require the JSD Agent to select the Organization, and *then* select it again in an Insight field :-(

Yes, it's not an optimal solution, but the closest thing that can be done.

Just a thought, it should be possible using an post function to set the organisation field afterwards, and in that way only use the insight organisation field to restrict the other fields, and then when the issue is created, the "real" organisation field could be set by default to the same field as the Insight organisation.

Best Regards

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

447 views 8 26
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you