IQL Filter with 2 conditions

Pierre-Yves Elie

Hi,

 

I'm stuck with Insight and after many crazy hours I need help

I have an object type "Client" (database of 500 clients)

I have an object type "Product" (database of all produts to maintain)

 

Each "Client" can have one or more "Product".

In the object, I would :

1. Choose the Client impacted by the issue
2. Choose the Products, but filtered with only the "Product" owned by the Client herebefore.

 

Thanks for your precious help !

 

 

Melo_45tw58

Hi @Pierre-Yves Elie, I'm unsure if I fully understand the requirements.

You can use something like "Name" LIKE "Client name" AND "Product" IN ("My product 1", "My product 2")

There are other ways like using the reference too e.g. object HAVING inboundReferences("Name" = "Client ")

Or by reference type e.g. having inR(objectType = "Client", refType IN ("Reference type used for Product"))

You can find more examples here: https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/

I hope that helps.

Thanks,

Melo