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*. 

issue in fieldMatch("project = SEARCH", "description", "find issues mat*")

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

[Bijoy]

I'm not using cloud version.

[mauricio.groth]

Hi @Bijoy 

Thank you for replying.

I have edited my answer to our information about Jira Server, please check it again :)

Please, let us know if you have any further questions

Best regards,

Maurício Groth

[Bijoy]

Okay, I will try to connect on Monday.

And can inform the update.