How to get the date of the first issue created and the date of the last issue created in a project?

SIN_9k3fzu

My client is using Projectrak with Jira and he needs to know the creation date of the 1st issue created date (will update the actual start date field in projectrak automatically using jira automation) and the creation date of the last issue created (will update the actual end date field in projectrak automatically using jira automation).

Are we able to do this using jira automation?

Appreciated for your help~

 

Thanks

Trudy P Claspill

Hello @SIN 

Do you need a single rule that will work against multiple projects?

How many issues exist in each project where the rule needs to run?

There is a Lookup Issues action that can be used to retrieve issues based on a JQL, and you can pull the first and last issue from that data set, but it is limited to returning 100 issues. If your project has more than 100 issues you would need to add something to the JQL to try to limit the issues, perhaps with one JQL that includes criteria to select issues created before a given date to get the earliest issues, and a second JQL that includes criteria to select issues created after a given date (or in the past X days/months relative to the current date) to get the latest issues.