nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I create a filter by project to see when most recent update occurred?

Pete P_lbwqsx

How can I create a filter by project to see when last update occurred?

I need to provide an inventory of projects, the project lead and the most recent time an issue was updated in each project. Anyone know how I might achieve this? We have a lot of turnover and abandoned Jira projects strewn about I am trying to clean up.

Accepted answers

Zoryana Bohutska _SaaSJet_

Hi @Pete P

Maybe, you can find the solution at this discussion https://community.atlassian.com/t5/Jira-questions/SQL-to-return-for-every-project-most-recent-updated-date/qaq-p/437248

All comments

Zoryana Bohutska _SaaSJet_

Hi @Pete P

Maybe, you can find the solution at this discussion https://community.atlassian.com/t5/Jira-questions/SQL-to-return-for-every-project-most-recent-updated-date/qaq-p/437248

Daniel Ebers

Hi @Pete P

in more recent versions of Jira Server you could just navigate to:

https://jira.example.org/secure/project/BrowseProjects.jspa?s=view_projects

to get those information - they can be easily copy & pasted to Excel. A filter on that page directly is not possible, though.
jira.example.org must be replaces with valid data, of course.

Regards,
Daniel

Pete P_lbwqsx

Thanks @Zoryana Bohutska _SaaSJet_ , that page lead me to "Latest Activity Report for Jira" app which should do the trick.

https://marketplace.atlassian.com/apps/1210777/latest-activity-report-for-jira?hosting=server&tab=overview

Pete P_lbwqsx

Thanks @Daniel Ebers !

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-core

jira-core-server

project-lead