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.
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!
Great stuff Ahmad. This answers my question!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.