first issue creation date

[Gonzalo Fernández Durán]

Hello community,

as you all know, there is no way to get the project creation date as it is not stored in Jira. I´d need your imagination over issue fiters in order to create a filter to show the first issue created of many proyects.

Thanks in advance

[Iago Docando · Accepted solution]

create a script to query the API in 4 steps

1. retrieve the list of projects. GET /rest/api/3/project/search
2. iterate for each project key GET /rest/api/3/search?jql=project=<PROJECT_KEY>%20ORDER%20BY%20Created and store the first issue key returned for each poject
3. iterate for each issue key GET /rest/api/3/search?jql=key=<ISSUE_KEY> and store the results of the field "created" for each one
4. present the list of projects and their respective dates "of creation"

I hope it helps

[Fabio Racobaldo _Herzum_]

Hello @Gonzalo Fernández Durán ,

in order to retrive those information you should perform a DB query because using JQL you can't do that using bultin capabilities.

Out of the box there is a third part app that could help you https://marketplace.atlassian.com/apps/1213501/sql-jql-driver-transform-jql-into-sql?hosting=server&tab=overview

Hope this helps,

Fabio