How can I do JQL searches for Labels which contain white spaces?

Question

Hi everybody,

in our project it seems to be possible that white spaces in Labels can be used (nothing I can influence). Now I try to search in JIRA using JQL for all entries with an attribute that containes label entries where an entry matches the pattern 1stword 2ndword (so the Label is named for example "1stword 2ndword" containing a whitespace inbetween).

Whatever I tried so far - nothing works. I tried to put the label string inside "" but I only get an error "The label "1stword 2ndword" containes spaces which is invalid".

So how can I search/filter for JIRA entries containing this label? Also LIKE as an operator is not available and ~ operator is not working either.

Any idea on how to solve this?

Thank you in advance!

Hannes Obweger - JXL for Jira · Answer

Hi @Reth,

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 filter issues via regular expressions.

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

(I'm using components here as I didn't manage to create labels with whitespaces on my site - but it would work exactly the same way with labels.)

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