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; } } }

Can someone help me with JQL that uses a IQL function?

Travis Alexander _Empyra_

I have an Insight object type called 'Software'

I have objects A, B, and C as in the 'Software' object type

I have a custom field called 'Affected Software', populated with insight objects A, B, and C.

I need JQL that returns me a list of all issues where 'Affected Software' has options A and B selected.

Accepted answers

Mark Segall

Hi @Travis Alexander _Empyra_

You'll want to incorporate iquFunction into your query. Here's an article that describes it.

https://support.atlassian.com/jira-service-management-cloud/docs/insight-jql-functions/

All comments

Mark Segall

Hi @Travis Alexander _Empyra_

You'll want to incorporate iquFunction into your query. Here's an article that describes it.

https://support.atlassian.com/jira-service-management-cloud/docs/insight-jql-functions/

Travis Alexander _Empyra_

Thanks, Mark. I've actually see this - I just can't it to work.

Mark Segall

Hi @Travis Alexander _Empyra_

For clarity, not sure if you're looking for either A or B if both must be selected. Here's a sample of how each would work:

Either A or B exists

customField in iqlFunction ("attribute IN (A, ")

Both A AND B exists

customField in iqlFunction ("attribute = A") AND customField in iqlFunction ("attribute = B")

Hopefully this helps.

Björn Gullander

Did you get it to work @Travis Alexander _Empyra_ ?

iqlFunction is a bit messy, sometimes it easy to get into problems with double quotes in the IQL query. To make it easier you can enclose the IQL query with single quotes instead of double quotes like this:

"Affected Software" in iqlFunction(' Name IN ("software A", "software B")')

would be the same as

"Affected Software" in iqlFunction(" Name IN (\"software A\", \"software B\")")

Björn

Travis Alexander _Empyra_

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jql

insight

iql

jira-service-management-cloud

jira-service-management