IQL - Exact match with lists

Question

Hi,

i'm currently trying to write a script which determines the security level of a given Request upon creation based on the settings of an insight field.

Now i'm running into the issue that when using IQL I have no means of checking a list for an exact match.

For example, even with the IQLs

"Teams" == BUSIT AND "Teams" == DEVSUPP

"Teams" IN ("BUSIT","DEVSUPP")

I will still get additional objects, as e.g. there is also one object that has these two in the list, but on top of that a few others as well.

Best regards
Thomas

David Sumlin · Answer

Sometimes helps to reindex the objects also if the results don't seem to be matching your IQL.

Thomas Scheibelhofer_7g3fef · Answer

Hi Joshua,

yeah, i worked with IQL for a few years now and just never had the need of exclusivity.

A combination of IN and NOT IN might work if i'd know all the values beforehand, which I'm not going to have.

My current approach is to get a list of all objects which might fit and then compare the lists directly in groovy, but somehow that seems very tedious for a simple comparison.

Best regards

Thomas

Joshua Sneed Contegix · Answer

Hi Thomas,

I would start by reviewing the IQL documentation and looking into the available Operators. Assuming you have done/will do that, you may need to use the IN and NOT IN operators to bookend the exact results you would like. Cheers!