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

IQL Multiple Select

I am very new to Insight and IQL and forgive me if I ask the question incorrectly. The best way of explaining the issue is that I want to be able to have a drop down list for example that contains Countries and I can select multiple countries at once i.e. UK, France and Germany. I then have a 2nd drop down list that will present cities in those countries so my 2nd drop down should be dynamically populated with London, Birmingham, Manchester, Paris, Nice and Berlin etc. Can I write an IQL statement that will do this? 

1 answer

1 accepted

2 votes
Answer accepted

@Dave Ellard

I was able to do this by created City as an object type in my Object Schema. For each city, I have a text line attribute called Country that marks what Country it belongs to (this could be a picklist as well).

On my other object type, I have a Country attribute which is a picklist with all my countries, and then an Object selector attribute for the City attribute. For the city attribute, I filter using the IQL:

Screen Shot 2021-02-24 at 3.07.43 PM.png


As I update the countries in my picklist, I can see the city options changing to match!

Hi Kian, thanks for the fast response. I've not had a chance to try out your solution. Does it allow you to select multiple countries in the first list i.e. France and Germany and then the 2nd list to show Paris, Nice and Berlin?

Yes sir!

Perfect solution. Thank you very much!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Security Advisory for Jira Service Management

On October 20, 2021, Atlassian published a security advisory for Jira Service Management. The full advisory is available at this link.  We've seen a number of questions already asking for...

196 views 1 2
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