JQL Query to search with comment

Mallikarjuna March 19, 2024

how to define JQL Query to search issues with comments

 

2 answers

1 vote
Jerrold - Empyra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 19, 2024

Hi @Mallikarjuna 

You can use this JQL 

project = Demo AND (comment ~ "any*" OR comment !~ "any*")

This will bring issues in the demo project which has comments.

Thank you.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 22, 2024

Hi @Mallikarjuna

I trust that @Jerrold - Empyra's answer helped finding the relevant issues!

Just for future reference, if you're looking for more advanced comment-related searches, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the number of comments, the last commenter, and many, many other comment-related columns.

This is how it looks in action:

number-of-comments.gif

As you can see above, you can easily sort and filter by the number of comments, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer