Needed to search like % in some fields but not full word with ~syntex.

Bijoy

Needed to search like % in some fields but not full word with ~syntex.

Can share your options or solutions?

 

mauricio.groth

Hi @Bijoy 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use our function fieldMatch which matches issues with a field containing a specified text (case-sensitive). This function works with custom fields too. You can use the asterisk (*) to match any text. For example, with this query, you will find all issues with the description field matching the regular expression find issues mat*. 

"project = SEARCH",<span>&nbsp;</span>"description",<span>&nbsp;</span>"find issues mat*")issue in fieldMatch(

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício