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]

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