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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.