[CLOSED] Optimization JQL in Advanced searching

Question

Hello, I struggle to optimize my code. I want to make something like this :

"Group in charge" = "FR-ENG-SCP*" that will show me every group in charge that start with FR-ENG-SCP

but it's no the right syntax and I don't even know if it's possible.

If you know how to solve my problem, any help is appreciated.

Nic Brough -Adaptavist- · Accepted Answer

I'm afraid JQL doesn't do "fragment of name" searches.  Groups need to be uniquely identified in a list.

Kishan Sharma · Accepted Answer

Hi @Matheo CAPITAINE as Nic mentioned it is not possible to do. Can you please confirm if "Group in charge" is a custom field and whether it is a user picker type ?

Daniel Turczanski - JQL Search Extensions · Accepted Answer

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, dependencies, and, you guessed it, text patterns.

If you're serious about JQL you should look beyond standard Jira.

The big mistake Jira users make is they forget about exploring the app marketplace. Our app, JQL Search Extensions, solves JQL limitations.

For example, you can use the wildcardMatch JQL extension:

issue in wildcardMatch("Group in charge", "FR-ENG-SCP*")

Alternatively, you may be able to work around any JQL reporting limitations with an Excel export. This doesn't work well if you want to reuse the query repeatedly.

So, if you're fine with apps, this is the solution for you.