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

[Abdelrahman R]

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

[Hannes Obweger - JXL for Jira · Accepted solution]

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:

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

[Rilwan Ahmed · Accepted solution]

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" '

[Abdelrahman R]

Dears @Hannes Obweger - JXL for Jira & @Rilwan Ahmed ,

I really appreciate your fulsome support.