nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

jira_admin_cu

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!

Accepted answers

Alex_dddmmh

Hi @jira_admin_cu

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%%

Screen Shot 2020-11-04 at 9.40.38 AM.png

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

All comments

Alex_dddmmh

Hi @jira_admin_cu

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%%

Screen Shot 2020-11-04 at 9.40.38 AM.png

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

Emre Toptancı [OBSS]

Hello @jira_admin_cu ,

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

Bill Sheboy

Hi @jira_admin_cu

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

Gökçe Gürsel {Appfire}

Hi @jira_admin_cu ,

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.

image2017-8-23+17_31_37.png

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.

jira_admin_cu

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira-software

jira-software-server