ScriptRunner Advanced Search assistance

[Max Marx]

We have recently migrated from Jira server to Jira cloud.

I have been tasked with looking for the amount of time between created, then time between any of the following transitions until work item is in PROD:

• ProjectXYZ = starting on Sept 1, 2021 to now and can pull same data upon request:

  • Date and Time any ticket was created.

  • By all other priorities.

  • Date and Time any ticket was transition into a sprint

    • Date and Time any ticket was transitioned through To Do, In Development, Pull Request/Merged, In Testing, Testing Complete to Done, then in PROD (the time between Done.

I found this link ( https://community.atlassian.com/t5/Jira-questions/How-to-write-a-JQL-to-show-date-when-issue-status-CHANGED-FROM/qaq-p/625509) that helped but I am unable to determine which date field to use to get the status transition change date. 

I wrote the following using ScriptRunner Enhanced Search which returns all the Jira issues I want but it does not return the transition change date field. 

project = ProjextXYZ AND Status changed from ("IN DEVELOPMENT") to ("PULL REQUEST") AFTER ("2022-08-31") AND type in (story, task) ORDER BY created

I selected the 'Status Category Changed' field but it displays the latest status transition date and not when the transition I query against took place.

I would appreciate any help.

Thanks

Max