JQL search query

[Jaeson Hillary]

Search query to find any projects that doesn't have a new ticket within the last year?

[Daniel Ebers]

Hi @Jaeson Hillary

welcome to the Atlassian Community!

I must pass for the full requrement of "new" during last year. The nearest idea that comes to mind is to browse to: https://YourSiteName.atlassian.net/secure/project/ViewProjects.jspa and to look at the column "Last issue update".

Cheers,
Daniel

[Bill Sheboy]

Hi @Jaeson Hillary  -- Welcome to the Atlassian Community!

I don't know how many projects you have or how much activity/new issues are created, but how about turning this around the other way: search for things created in the last year and then whatever is left is the "idle" projects list.

For example, search for:

created >= -365d ORDER BY Key

Could return up to a 1000 issues.  Anything you can do to reduce that helps.  Let's say your projects always use epics, that could greatly reduce the list with:

created >= -365d AND issueType = epic ORDER BY Key

Whatever you find, you will still want to confirm that the projects are "idle" before taking any actions.

Best regards,

Bill

[Jaeson Hillary]

Hi,

Can I know, what do you mean by whatever is left? You mean subtracting  the results I get from the search query you gave from the total issues I have?

Thanks,

Jaeson.B

[Bill Sheboy]

Hi @Jaeson Hillary 

For whatever is left, I meant the project list.  However...

I suggest trying the link Daniel provided as that includes the full project list and a field with the last issue update date.  Sorting by that date will answer your question.  If it does so, please mark his suggestion as the answer to help others find this solution.  Thanks!

Best regards,

Bill

[Jack Brickey]

JQL works on issues not projects so this isn’t possible. It would be nice to be able to find ‘idle’ projects. There may be addon options but I don’t have firsthand experience with any. I saw one called Project Labels and wonder if you could use to achieve your goal along with automation. Of course it would only work in the future not the past I suspect.