IQL not working when Placeholder Field has Multiple Values

[David Harkins]

We have the following IQL / AQL on one of our fields, simplified for this question.

"JIRA Service Desk ID" IN (${customfield_10110})

Customfield_10110 is the Organizations field and returns the IDs of the Organizations.

Within Insight / Assets we have Organizations Object with a 'JIRA Service Desk ID' attribute.

When the Organization field contains only one value, the above works fine.

If the Organization filed has more than one value, I would expect the respective objects to be listed, but none are.

[David Harkins · Accepted solution]

I had to use the following IQL / AQL to get this working:

"JIRA Service Desk ID" IN (${customfield_10110${0}})

This was noted from the Insight / Assets import documentation when importing attributes with multiple values. 

[Marc - Devoteam]

Hi @David Harkins 

I'm not an expert on Assests but,

What type value does the attribute 'JIRA Service Desk ID' have.

If it is text, only 1 value is allowed.

[David Harkins]

JIRA Service Desk ID is of an Integer type.

We can query Insight / Assets directly like

'JIRA Service Desk ID' IN ( 1,2,3,4)

So it is possible to query the field that way in Insight / Assets directly.

[Marc - Devoteam]

Hi,

This might do the trick:

"JIRA Service Desk ID" IN (${customfield_10110.JIRA Service Desk ID})

This as, I think, Assets looks at the result from the "Custom Field" at the Value ID's e.g. (selectedValue=14103) instead of the actual value 1 or 2.

[David Harkins]

It works perfectly when customfield_10110 has only one value (Organization) stored.

would then be similar to:

"JIRA Service Desk ID" IN (1)

If customfield_10110 has two values, my assumption is that it would be along the lines of:

"JIRA Service Desk ID" IN (1,2)

But no results are returned