nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter JQL doesn't work as expected

Evert Morren

I am trying to find tickets with in the description the text ZOA-Manager or ZOA-manager or zoa manager. I made a JQL filter description ~"ZOA-Manager". The filter match on all tickets with the words ZOA and Manager, for example it match on the description 'ZOA this is a test manager'.

I need a filter that only match the phrase ZOA-Manager, ZOA-manager, ZOA manager.

Accepted answers

Pramodh M

Hi @Evert Morren

Please try the below JQL and let me know the result

text ~ "\"<span style="background-color: #ffffff; text-align: left; text-transform: none;">ZOA-Manager</span>\""&nbsp;OR&nbsp;text ~ "\"<span style="background-color: #ffffff; text-align: left; text-transform: none;">ZOA manager</span>\""

Reference - Here

https://confluence.atlassian.com/jiracoreserver/search-syntax-for-text-fields-939937723.html

Thanks,
Pramodh

Daniel Turczanski - JQL Search Extensions

JQL filtering is powerful, but you can hit its limits in more complex workflows.

You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations, and - you guessed it - text patterns.

So, if you're serious about JQL, look beyond standard Jira.

The big mistake Jira users make is they forget about exploring the app marketplace. Our app, JQL Search Extensions, is a good example of a solution to JQL limitations.

For example, in your filter, you can use the exactTextMatch JQL extension:

issue in exactTextMatch("ZOA-Manager")

Alternatively, you may work around any JQL reporting limitations with an Excel export. This doesn't work well if you want to create a filter for the board though.

All comments

Pramodh M

Hi @Evert Morren

Please try the below JQL and let me know the result

text ~ "\"<span style="background-color: #ffffff; text-align: left; text-transform: none;">ZOA-Manager</span>\""&nbsp;OR&nbsp;text ~ "\"<span style="background-color: #ffffff; text-align: left; text-transform: none;">ZOA manager</span>\""

Reference - Here

https://confluence.atlassian.com/jiracoreserver/search-syntax-for-text-fields-939937723.html

Thanks,
Pramodh

Evert Morren

H Pramodh, I have made the JQL, but it match also on:

ZOA

This is a test, please do this or that .

Your Manager

It seems the JQL search for the words ZOA or Manager and not for the phrase "ZOA-Manager"

Regards,