nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

David Harkins

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.

All comments

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

David Harkins

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

insight

jira-service-management

jira-service-management-server