Sort on tickets based on when they transitioned into a new status in JIRA.

[Lakshmi CH]

Hello Team,

 I want to sort on tickets based on when they transitioned into a new status in JIRA.  The Transition Date field would contain a date of when the ticket was moved into its current status. For example if we move a ticket into "Ready For Review" today, the field should show "11/04/2020" and need to get results in JQL. I have Script Runner, JSU, JMWE plugins installed and the jira version is 8.7.1. Could you please suggest how to achieve this ?

Thanks!

[Alex · Accepted solution]

Hi @Lakshmi CH 

My suggestion is to add the post-function Update Any Issue Field (JSU) on the transition to "Ready For Review" status and define the value of the custom field as %%CURRENT_DATETIME%% 

Every time the issue transition to Ready For Review the date will be logged and you can JQL this field.

I hope it helps,

Cheers,

Alex

[Lakshmi CH]

Hi @Alex , Thank you, I tried this approach and it is working as requested.

[Gökçe Gürsel {Appfire}]

Hi @Lakshmi CH ,

Enhancer Plugin for Jira has date fields that can help you with your requirement.

Just navigate to the Date fields section in the Enhancer plugin for the Jira menu, add your Status Entry Date, select the status you want to show information about, add it to the necessary screens and it'll start capturing details. Alternatively, if it suits your workflow, you can also use built-in First In Progress/Reopened/Closed Status Dates.

You can also obtain historical information about the already existing issues too. These fields are searchable, sortable and you can use them in reports too. Also, JEP has dedicated gadgets that can help you to track your progress.

Please let me know if you have further questions.

Cheers,

Gökçe

Please note that I'm one of the members of the Snapbytes team.

[Bill Sheboy]

Hi @Lakshmi CH 

For the cloud version, there is a field called statusCategoryChangedDate which can be used for this purpose with JQL.  Does this field exist in the server version, as I could not find it in the help documentation?  If so, you could use that to order the issues.

If that one is not present, you could add a custom field and set it using an automation rule when the status changes.  Then you could search and filter on that information.

Best regards,

Bill

[Emre Toptancı _OBSS_]

Hello @Lakshmi CH ,

Our app Time in Status might help you about this.

Besides giving reports about how much time each issue spent on each status, assignee or group; Time in Status also gives reports showing the first/last transition dates for each status of each issue.

The app works by processing your existing Jira issue histories so you won't have to modify your workfows, create new custom fields or make any configuration on Jira. You will also be able to report on your past issues.

The app allows you to export data as CSV or XLS.

Timepiece - Time in Status for Jira

EmreT