IQL to check the object type of an attribute value

[mvdetten]

Hi community!

I have a quick IQL question that I could not find an answer for as of yet:

I have two Insight object types DEVICE and CONTRACT. A device can have many contracts and stores them in the attribute device.contracts. In addition CONTRACT has two sub types CONTRACTA und CONTRACTB. Now I want to filter all objects to only return objects that have contracts of type B.

So I guess I would need some IQL like "contracts IS NOT empty AND contracts.objectType = CONTRACTB". Unfortunately it doesn't work that way. Can anyone help me?

Cheers,

Markus

[Hana Kučerová · Accepted solution]

Hi @mvdetten ,

please look at function inbound/outboundReferences.

Your IQL could look something like this: 

objectType = DEVICE AND object HAVING outboundReferences(objectType IN ("CONTRACTB"))

[mvdetten]

Oh right! I always have difficulty wrapping my head around the inR and outR functions. But that worked.

Thanks for the quick reply!