Filtering Options with Regular Expression and Operators

ntt.guruplar July 19, 2024

Hello,

what are the regular expression rules in Jira?
How can I set a filter with regular expressions? 

I want to use a text filter which has these three options:
Match Case, Regular Expression, and Operator but it's not really clear for me how to use them.

Thank you and kind regards,

Sinem

2 answers

Suggest an answer

Log in or Sign up to answer
2 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 19, 2024

Hi @ntt.guruplar 

Native it's not possible to use regex in JQL search options

You can only use Contains (~) or Does Not Contain (!~).

See the documentation -> jql-operators CONTAINs 

ntt.guruplar July 22, 2024

Hi Marc,
thank you for your quick response.
I tried some options but it doesn't work for me. I added screenshots.
In both examples it shows me the same. 
What am I doing wrong?

Like John Funk likes this
ntt.guruplar July 22, 2024

1Filteroption Text Jira.PNG

Hannes Obweger - JXL for Jira
Atlassian Partner
July 22, 2024

Hi @ntt.guruplar

jumping in here as your screenshot shows JXL for Jira :)

What you are seeing here is a so-called column filter. This column filter doesn't use JQL, but its own, more powerful search technology. E.g., you can use logical operators or regular expressions.

From what I see in your screenshot, you want to exclude all issues where Stufe 1 is DES_EXT@VEA-CL_VG_XX_MITTE - is this correct?

If so, mind trying the following:

NOT DES_EXT@VEA-CL_VG_XX_MITTE

Please let me know if this works. If it doesn't, may I ask you to reach out to us at https://support.jxl.app so that we can look into your use case in more detail?

Thank you,

Best,

Hannes

Like John Funk likes this
1 vote
Hannes Obweger - JXL for Jira
Atlassian Partner
July 20, 2024

Hi @ntt.guruplar

as Marc correctly suggested, regular-expression-based filtering isn't natively supported in Jira/JQL.

However if you are open to solutions from the Atlassian Marketplace, you'll find a number of apps that either extend JQL by additional function, or offer their own, non-JQL search and filter mechanisms.

As an example, regular-expression-based filtering is available for all fields in the app my team and I are working on, JXL for Jira.

This is how it looks in actions:

regex-filtering-labels-pattern.gif

For context, 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.

Any questions just let me know,

Best,

Hannes

ntt.guruplar July 22, 2024

Hi Hannes,

thank you for your support and the information.
Which apps do we need therefore? Do you have a link or a documentation for me regarding the regular-expression-based filtering app?

Thank you and kind regards,

Sinem

Hannes Obweger - JXL for Jira
Atlassian Partner
July 22, 2024

Hi @ntt.guruplar

sure - please have a look at the relevant information on column filtering here and the use of regular expressions here.

If you haven't seen it yet, you may also find our quick demo video interesting.

Lastly, please feel free to reach out to us at https://support.jxl.app if there's anything we can assist with or clarify - we're here to help!

Best,

Hannes

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events