SQL to list Projects that don't have any issues created in them

Deleted user March 3, 2013

We have a bunch of old projects, some of them never even used. I've found 3, but I'm sure there are more. I'm after the syntax to do a search on the Jira Db that returns all projects with 0 issues in them.

1 answer

1 accepted

1 vote
Answer accepted
Faisal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 3, 2013

Hi there,

Since you would like to query the projects that doesn't have any issue created under it, then I believe that we may combine the project and jiraissue table in order to get the desire results. Kindly note that in jiraissue table, there's a project column which stores the ID of the project in project table.

Hence, I believe that you may run the following SQL statement to retrieve the projects:

select * from project where id not in (select project from jiraissue);

I hope that this will help!

Deleted user March 19, 2013

Great stuff Ahmad. This answers my question!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events