Why does the label field not support ~ operator?

[Bryan Moglia]

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?

[Trudy Claspill]

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

[Hannes Obweger - JXL for Jira]

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 hierarchies, issue 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:

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