How to find the details of the last Jira issue updated time and the total Jira issue count for all the projects

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

Summary

This article provides comprehensive instructions on the process of obtaining the most recent update time for issues, as well as the cumulative issue count associated with each Jira project.

Environment

Jira Cloud

Solution

  • We can utilize the Get Paginated Projects API that provides a paginated list of projects visible to the user. By default, the API response doesn't include the details of the "lastissueupdatetime" and "totalIssueCount". However, we can include the expand query parameter along with the insight option to view the "lastissueupdatetime" and "totalIssueCount" information for the projects.
    • The expand parameter is to include additional information in the response. This parameter accepts a comma-separated list.
    • The insight option returns the insight details of the total issue count and the last issue update time for the project.
  • You may use the following URL to retrieve the information:
https://<Your-Site-URL>/rest/api/3/project/search?expand=insight


  • The response would include the details in the below format:
"insight":{"totalIssueCount":177,"lastIssueUpdateTime":"2024-04-25T23:31:43.485+0300"}}
  • The actual count and date may differ depending on the projects.




Last modified on May 6, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.