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

How to reference EXACT 'list' configuration (equals operator)?

Lucas Molenaar_hp160x

I want to locate tickets that have a specific list selection. The tickets MUST have the exact configuration (so only one value match is not sufficient).

e.g. we have a custom field of type list named "platform", with 100 options (option1, option2, option3, ..)

I like to return all issues with

project = TEST AND issuetype = Bug AND platform = (option11, option61, option99)

When I use the = operator, I get the following error:

Operator '=' does not support the list value '("option11", "option61", "option99")' for field 'platform'.

What is the right syntax to return issues with the exact queried list configuration?

Accepted answers

All comments

Jack Brickey

Use the “in” operator…

project = TEST AND issuetype = Bug AND platform in (option11, option61, option99)

Lucas Molenaar_hp160x

This also returns:
(option11, option61)
(option11)

The tickets MUST have the exact configuration (so only one value match is not sufficient).

Jack Brickey

project = TEST AND issuetype = Bug AND platform = option11 and platform = option61 and platform = option99

however, this will not exclude issues that also include additional platform values. There isn’t an “only =“ function.

Bill Sheboy

Hi @Lucas Molenaar

Yes, and...to what Jack suggests: How often do you need to perform this query?

If you need it once, you could brute force it, by adding a clause to exclude all of the other options:

... AND platform NOT IN (option1, option2, ...)

Or, export to a spreadsheet to prune the list by option count.

If you instead need this often, you could investigate the marketplace for JQL addon apps which support such query syntax, or you could build an automation rule to do this. (Such a rule would perform your query, and then check for issues with a count of options exactly equal to 3. I've never built such a rule but I suspect it is possible.)

Kind regards,
Bill

Daniel Turczanski - JQL Search Extensions

If the options follow a pattern, you may find our regex JQL function handy to filter out issues with additional options. It's part of JQL Search Extensions.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql