Add to a filter the status history of issues

Question

I created a filter using Jira Query Language to view all the issues from a project. On the view I have several datapoints like key, reporter, status etc and some additional custom fields that were created specifically for the project.

I want to add on the same filter information about the date and time when the issues have had changes on status (in addition to the current status I already have). It should include the "CHANGED FROM" and "TO" of the status. to confirm the it has been updated with its corresponding date.

Mariana_Pryshliak_Saasjet_qysy8m · Answer

Hello @Gabriel Carvajal

There are 2 solutions, which can be helpful!

Time in status for Jira Cloud generates Status Entrance Date report, which shows the date and time when the issue has entered each of the statuses, and + data points like a key, reporter, status etc, and some additional custom fields.

Issue History add-on tracks all the changes that have been made to each issue, including status change, and the author of changes.

I hope, you find it helpful

Best regards, Mariana

Emre Toptancı [OBSS] · Answer

Hello @Gabriel Carvajal ,

JQL only allows you to filter issues based on given criteria. Each row in the output represents an issue and the columns you can show in issue search page are issue fields only. Unfortunately there is no out-of-box option to display information from issue history and/or related issues.

Since you are on the cloud, you get try getting this information from the REST API, which requires some software development or you can use a ready built app to get the data.

For a ready built solution that offers great fexibility and details, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee as well as entry/exit dates for all statuses. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time.

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Using Time in Status you can:

* See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
* Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
* Define custom calendars for reporting.
* Export your data as XLS, XLSX or CSV.
* Access data via REST API.
* Visualize data with various chart types.

Timepiece - Time in Status for Jira

EmreT

Mehmet A _Bloompeak_ · Answer

Hi @Gabriel Carvajal ,

As Kat mentioned "status CHANGED BEFORE" is the only hint for you case. But as far as I understood, you also want to filter by "from" and "to" values. Unfortunately it is not possible with Jira Query Language.

But the data is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, then you need to extract and calculate for each issue.

Or as an alternative, you can check marketplace apps. One of them is Status Time app developed by our team. It provides status entry dates apart from status durations.

Here is the online demo link, you can see it in action and try.

Hope it helps.