Is there a way to search for a portion of a label?

[Steven Johnson]

I am trying to create a condition with Jira Automation that will check if any labels exist that end with "_XYZ", so I'm trying to use JQL search to figure out if that can be done. Is there a way to search for just a portion of a label (say in the Labels 1 field) that contains the _XYZ ending (ex. 1234_XYZ)?

We are not able to add third party add-ons, so I'm wanting to know if this is possible in any way?

Thanks!

[Hannes Obweger - JXL for Jira]

Hi @Steven Johnson

to the best of my knowledge, this isn't available in plain JQL. The only native solution that I can think of to find these issues is to export your data to e.g. CSV and perform your search in post-processing.

I understand that you are looking for a built-in solution, but in case a Marketplace app should become an option for you, you'll have a number of apps available. I'll add more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on my last point: If a Marketplace app should become an option for you, I think you'd like 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 filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

The regex that I'm using is

.+_XYZ

- but of course, you have full control over that.

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Any questions just let me know!

[karim -Atlassway-]

Hello @Steven Johnson ,

Try out Colored Label Manager , it can helps you.

Atlassway

Karim