[CLOSED] Optimization JQL in Advanced searching

[Matheo CAPITAINE]

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.

[Daniel Turczanski - __JQL Search Extensions · Accepted solution]

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.

[Matheo CAPITAINE]

Thank you for your response, I am not familiar yet with this plateform.

[Kishan Sharma · Accepted solution]

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 ?

[Matheo CAPITAINE]

Hello, yes it's a custom field and i can't modify it.

[Nic Brough -Adaptavist- · Accepted solution]

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

[Matheo CAPITAINE]

Ok thank you for your help.