Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,854
Community Members
 
Community Events
168
Community Groups

How to retrieve all jiras with empty comments regardless the status, using JQL

How to retrieve all jiras with empty comments regardless the status, using JQL

3 answers

2 accepted

0 votes
Answer accepted

Hi @Abdelrahman R

as another alternative, you can use JXL for Jira to find your issues.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, and sorting and filtering by all your issue fields, plus a number of "special fields" that aren't natively available. The "number of comments" is one of these special fields.

This is how it looks in action:

number-of-comments.gif

From here, you can start working on your issues directly in JXL, trigger various Jira operations, or export your issues for further processing. JXL works for all platforms (Cloud, Data Center, Server). Disclaimer: I work on JXL.

Hope this helps,

Best,

Hannes

0 votes
Answer accepted
Rilwan Ahmed Community Leader Aug 16, 2022

Hi @Abdelrahman R ,

In native jira, you cannot find tickets with empty comment

Workaround for Jira server:

  • Install JIRA Tool Kit plugin and add a custom field of the type 'Number of Comments'
  • Then you can search for ' Number of Comments = "0" '

Dears @Hannes Obweger - Fine Software - JXL & @Rilwan Ahmed ,

 

I really appreciate your fulsome support.

Suggest an answer

Log in or Sign up to answer