How to filter out attribute options based on another attribute in Insight using IQL

[Robert Jober]

We have a insight object type called IT Release and an insight object type called IT Product.

IT Release is linked to the IT Product therefore the IT Release has an attribute of type object and the attribute name is Product.

IT Release can also have impact on other IT Products so we have a another attribute of type object with a name Impacted Products.

The selection for both attributes Product and Impacted Products in the IT Release is the same as it based on IT Product list.

We would like to change the behaviour for Impacted products attribute in a way that a user can select any IT Product except the one that has already been selected in the Product attribute.

is this possible?

The attribute configuration screen has three tabs: General, Cardinality and Filter objects. In the Filter object one can eneter IQL. What would the IQL be for this scenario?

[Yinon Negev]

Hi Robert.

     You are correct to assume that the "Filter Object in the "Impacted Products" Attribute should be the way to go.

Please try with the following IQL:

Name NOT IN (${Product})

This will make sure that the Name of any object Referenced in the "Impacted Products" attribute will not be one of those indicated in the "Product" Attribute (represented here by a placeholder).

Additionally - if more than one Object can be referenced in "Impacted Products" please configure the Attribute's Cardinality accordingly.

Kind regards,

Yinon

Team Riada