Can I use JQL to search for projects that contain no issues?

[G Sunil Kumar]

Hello,

Is it possible to identify the projects that created but not a single issue is created using JQL? 

Regards,

Sunil

[Daniel Ebers]

Assuming you have admin privileges it might be easier to read the value from projects list (Admin "Cog" > Projects).

[John Funk]

Hi Sunil,

Could create a filter with all issues (maybe something like Created >= 2000-01-01) and then create a dashbaord with the Issue Statistics gadget.

Use the Project field for Statistic Type. 

This will show you a count of all of the issues on that project. If the project is not listed, then there are no issues. 

It's a backwards way of doing it, but it will probably show you what you want. 

[Nic Brough -Adaptavist-]

You can not search for what is not there.

The best you can do is infer (work out) the list of empty projects from the results of searches for non-empty project.

Create a search for all issues (essentially, no JQL at all!) and save it.  Go to a dashboard and add a "filter statistics" gadget, selecting "project" as the statistic.  Go back to the dashboard and you'll see it gives you a list of projects that do have issues.  Take that list and subtract it from the full list of projects from "all projects".  What you have left is empty projects.  (Note that the gadget is limited in numbers it can display, you may need to whittle it down by adding "project not in (aaa, bbb, ccc)" clauses to it as you rule out the larger rojects)

[Tadas Apulskis]

wow, that's a great answer thinking outside the box! 

[Nic Brough -Adaptavist-]

I've always had "fun" finding dead projects, to the point where I created a project report for admins as one of my earliest plugins (for version 3.0.3 of Jira, to show my age!)

One thing to remember about doing it this way is consistency.

If you are logged in as an admin, and you use the administrators project list, you will need to be careful - the gadget only reports on projects you can see, but the Jira and system admins see ALL projects.  So if you find a project is not in the gadget, it may be an empty project, or it may be a project that you cannot see with your account!

[Alexis Robert]

Hi @G Sunil Kumar , 

JQL is used to retrieve a list of issues, so you won't be able to create a query that would give a list of projects. 

What you can do however is create a new Statistics gadget on your dashboard, use a filter that will retrieve all issues. That will give you the list of all projects with at least one issue.

You can then make a list with all projects and see which are not in the "at least one issue" list.

Let me know if this helps, 

--Alexis

[KAGITHALA BABU ANVESH]

Hi @G Sunil Kumar ,

JQL is able to display only when the issue field data is available or not.

If you are a Jira admin and using server version.

Settings --> projects --> 

If you can sort, you will able to find projects with 0 issues.

[Tadas Apulskis]

i think doing it with rest API is better