Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I list old projects in Jira?

Leandro Nunes
Contributor
May 23, 2011

Is it possible to retrieve a list of projects without activity along the last e.g. 15 days?

4 answers

1 accepted

2 votes
Answer accepted
spuddy ಠ_ಠ
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 23, 2011

This is no direct way to do this in the JIRA UI, but you can get that information using a SQL query against the JIRA database.

select * from project where key not in (select distinct(pkey) from jiraissue where updated > "insert your date here")

1 vote
Aimee Swift
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2020

If you are looking for a SQL that will pull through things that are X days/months old from the current date for archival candidates, this worked for me:


select project.pname, project.lead, project.pkey,MAX(UPDATED) as "Last Updated"
from jiraissue, project
where jiraissue.project = project.id
group by project.pname, project.lead, project.pkey
having max(jiraissue.updated) < Dateadd(Month, Datediff(Month, 0, DATEADD(m, -12, current_timestamp)), 0)
ORDER BY MAX(UPDATED) ASC

 

In this case, it shows projects that haven't been updated in 12 months or longer but you can just edit the time frame. Hope this helps :)

1 vote
Andrew Ardill
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.
May 23, 2011

To see a list of issues without activity in the last 15 you need to create a filter that specifies an 'Updated' date-range.

Select Issues->'Search for Issues' and expand the 'Dates and Times' section. Under the 'Updated' section write -15d in the 'From' box. Click the search button at the bottom, and you will be presented with a list of all issues that have not been updated in the last 15 days.

More time-range options can be found by clicking the date-range calendar icon next to the 'From' box.

Andrei [errno]
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.
May 31, 2011

OP asked about JIRA projects though, not issues.

0 votes
Kishore Srinivasan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 26, 2014

select project.pname, project.lead
from jiraissue, project
where jiraissue.project = project.id
group by project.pname, project.lead
having max(jiraissue.updated) < 'respective date';

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events