Why does the label field not support ~ operator?

Bryan Moglia
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 20, 2023

I'm trying to create a saved filter based on a partial match of existing label values but I receive the following message: "The operator '~' is not supported by the 'labels' field."

Why is that?

2 answers

2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 20, 2023

Hello @Bryan Moglia 

Welcome to the Atlassian community.

The CONTAINS operator applies only to text fields.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CONTAINS-CONTAINS--

Labels is a multi-select list field, therefore the CONTAINS operator cannot be used with it.

You can add your vote to a change request on this topic here:

https://jira.atlassian.com/browse/JRACLOUD-23038

It is possible to do such a search if you are willing to acquire a third party product.

Adaptavist Scriptrunner and their less expensive Enhanced Search product offers an issueFieldMatch function.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

JQL Search Extensions offers a wildcardMatch function.

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3196354728/Text+JQL+functions#WildcardMatch

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 12, 2023

Hi @Bryan Moglia

welcome to the community!

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 hierarchiesissue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to perform text matching on all your issue fields:

text-filtering-labels.gif

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 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events