JQL Query to search with comment

Mallikarjuna
Contributor
March 19, 2024

how to define JQL Query to search issues with comments

 

2 answers

1 vote
Jerrold - Empyra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
Atlassian Partner
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