Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

how to get last issue update for all projects

Hello Team,

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?

Thanks.

5 answers

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.

<your.jira.site>/rest/api/2/search?jql=project=PROJ+ORDER+BY+updated+DESC&maxResults=1&fields=updated

Hi Mark,

Can you please help me with the script. I am also looking for such kind of stuff.

0 votes
Darryl Lee Community Leader Feb 11, 2021

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.

@Darryl Lee 

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. 

Darryl Lee Community Leader Mar 11, 2021

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.

3b432e49-1be3-4da5-ad8a-7edd3d294fbc

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...

Darryl Lee Community Leader Mar 11, 2021

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.

Friggafragging dynamically loading Javascript grrrrr....

(Oh how I long for the olden days of simple server-side apps that are easily scrapeable as HTML.)

Like Phillip Ponzer [Cprime] likes this

[posted under wrong account]

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.

I don't understand what are you trying to get. List of projects that were updated? Every one of them was updated at the certain period of time.

Hello @Damian Wodzinski ,

Sorry for the confusion.

We want to get the last issue updated date of each project.Capture.PNG

Like Marie NB likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you