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

JQL query to filter dropdown field values that contain text phrases

James K_

Hello,

I am looking to create a report that checks the number of tickets for unsupported versions of software. When customer open tickets, I have a field with a list of our released versions (example "2.0", "2.1", "3.0", etc.) , and when support for that version ends we restrict the availability of the old fields and have options that include "(Unsupported)" (ex. "1.0 (Unsupported)", "1.1 (Unsupported)"). I've tried to write a JQL query as
[field name] ~ "Unsupported" or alternatively [field name] !~ "Unsupported", but I'm getting a message that "The operator '~' is not supported by the 'field name[Dropdown]' field."

Thanks!

Accepted answers

Mikael Sandberg

You should be able to use [field name] = "1.0 (Unsupported)", or if you are searching on multiple values [field name] in ("1.0 (Unsupported)", "1.1 (Unsupported)")

All comments

Mikael Sandberg

You should be able to use [field name] = "1.0 (Unsupported)", or if you are searching on multiple values [field name] in ("1.0 (Unsupported)", "1.1 (Unsupported)")

Raimon Colmenares

Awesome, thanks!

James K_

So the only way would be to specify all the versions that have "(Unsupported)", there isn't a way to search on values that contain a specific string from a dropdown menu?

Mikael Sandberg

No, wildcard searches is only available for text fields, like summary and description. You would need an app that extends JQL in order to do fuzzy searches on dropdown fields. If you look in the Marketplace you will find apps that can do this.

Hannes Obweger - JXL for Jira

Hi @James K_

if you are open to solutions from the Atlassian Marketplace, this would now be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to perform text matching on all issue fields:

For more sophisticated use cases, you can also use regular expressions.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

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