Fetch projects by recent activity

Christian Isaza October 23, 2024

Hello, community.

Today I would like to know if there is any one to fetch from Jira, Atlassian Admin hub or API the list of the projects that have had activity in a recent period of time.

I am working to organize our Jira/Confluence access based on groups instead of individual access to projects/spaces.

To do so, I have fetched through the Jira API a list of all of our projects, but I see it is about 300+ projects and would like to focus on creating groups only for the active ones-with recent activity.

So far, I haven't had any luck googling nor with AI assistance.

If anyone can share any tips I will be really thankful.

1 answer

0 votes
Marc - Devoteam
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.
October 24, 2024

Hi @Christian Isaza 

Via the Jira UI and the projects option, you can order the projects by "Last Issue Update".

Or look at the JIra API, based on Get projects paginated and use the orderby option and use the lastIssueUpdatedTime property or expand option and the insights property.

Christian Isaza October 24, 2024

Hey @Marc - Devoteam thank you for your response.

If you don't mind would you please share with me an example? (maybe screenshots or something) -I have been trying during the whole day to use Get Projects paginated but it won't work; only shows the first 50 projects and for the "next page" it throws nothing. And noticed that even those first 50 projects won't show the lastissueupdatedtime.

Hence, I tried with regular (deprecated) get all projects call and it's the same; I get the projects but I do not get the lastissueupdatetime.

In both cases I used basic auth, just in case.

Marc - Devoteam
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.
October 25, 2024

{{baseUrl}}/rest/api/3/project/search?startAt=0&maxResults=50&orderBy=lastIssueUpdatedTime&expand=insights&status=live

The output is ordered by lastissueupdatetime

Christian Isaza October 25, 2024

Thank you @Marc - Devoteam unfortunately, for some reason it is not working for me. It just shows the first 50 and the rest of the pages are just empty.

Marc - Devoteam
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.
October 29, 2024
Like Christian Isaza likes this
Christian Isaza November 6, 2024

Hey @Marc - Devoteam thank you so much for the help.

Like Marc - Devoteam likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events