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 project.id = 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)

 

Advertisements
Posted by:.

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s