IQL Multiple Select

[Dave Ellard]

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? 

[Kian Stack Mumo Systems · Accepted solution]

@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:

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

[Dave Ellard]

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?

[Kian Stack Mumo Systems]

Yes sir!

[Dave Ellard]

Perfect solution. Thank you very much!