In the projects browser page im able to get "last issue update" time for each project.
our requirement is to get this projects in a single page or can this be done using API?
I had a similar need and ended up writing a script that queries the Jira API for every project key. You can use the query below to get the most recent issue update for a project with key "PROJ" for example. It will return 1 result with only the "updated" date field of the most recently touched Jira issue for that project.
I was trying to create an export file of Projects with the same thing @Yuvi was asking for, the Last issue update column that is visible in the UI.
I found my answer with Optimizer for Jira. It allows you to add the "Last issue update" column to its listing of Projects, and then export that list as CSV.
I have DC and was wondering, when you say it allowed you to add the column to its listing of projects and then export that list as CSV, does it add an export feature in the System --> Projects section or does it open up the option to add the column in Issue Navigator to somehow pull projects by last issue update?
Right now, I have the column when I go to see all my projects in my instance but have no way to export the list so am curious. I don't have a solid way via Issue Navigator to narrow down by project versus issues so trying to get a better understanding whether this may meet our needs.
Optimizer has its own separate UI and section in Jira to display Projects and other various Jira objects that it can help you optimize.
As pictured below, their UI has the additional "Last Updated" column along with an export to CSV option.
A heads-up though: The trial license limits you to viewing/exporting only 25 projects. (I assume the vendor got tired of people "trying their app for free" and then after gathering the necessary info, not purchasing.)
It is indeed disappointing that that column is visible on the standard Jira manage projects screen, but not exportable. Perhaps I could script something to scrape those pages...
BAH, so much for my scraping idea. I went and did an acli renderRequest for 7 pages of Projects and it was all for naught.
(Oh how I long for the olden days of simple server-side apps that are easily scrapeable as HTML.)
It will be hard. You can write a script that is running trough all projects and is comparing the data of the last updated ones. Or if you can somehow order Issues in project by Updated Time and grab the newest one, this would be easier.
But I do not have a ready script for that.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events