In large companies, there are usually a large number of projects of which, most of them are currently inoperative. Therefore, from MrAddon we advise you to execute this query every year and list all those projects that since a certain date have not updated their tickets. The list includes the name and the key of the project and its leader, that way we can contact the indicated people that will help us decide if the project can be already archived. Here we give you an example of SQL:


select j.pname, j.pkey, j.LEAD from project j where j.pkey not in (select project.pkey from jiraissue, project
where = jiraissue.project and jiraissue.updated > "2019-01-01" )


Here a trick more to find or view a Jira issue from the database using SQL (here)


Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s