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
Sometimes helps to reindex the objects also if the results don't seem to be matching your IQL.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.