How to display projects with zero issue count in "Issue Statistics" gadget?

[Michael Voronkov]

I am looking for help with two things:

1. JQL query to find a list of projects where issuetype count is zero. Example projects with no bugs.

2. Projects with zero issue count do not show up in "Issue Statistics" gadget, but I would like to show stats for all projects, even for those with zero count.

Thanks in advance!

[Nic Brough -Adaptavist- · Accepted solution]

I'm afraid neither of these are possible! JQL searches issues, not projects. And the issue statistics reporting/gadgets all deliberately omit 0 counts because almost all searches are looking for results, not absence of results.

You'll need code to be able to do any of this

Ages ago, I wrote a really simple housekeeping report - listed all projects with their counts (and explicitly did not ignore zero counts). You'll need to do something similar for point 1. Point 2 requires rewriting the gadgets to stop them ignoring zeroes.