Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,717
Community Members
 
Community Events
165
Community Groups

I need to see list of issues where status changed back from IN QC, Ready for UAT to IN progress.

Edited

I need to see list of issues where status changed back from IN QC, Ready for UAT to IN progress.

I have checked various posts already here, and tried using 

project = "ABC" and status changed FROM "IN QC" TO "In Progress" and status ="In Progress"

But its missing out issues which I have transitioned.

-- Does the query check only for first transition?

 

For ex - 

Issue ABC-75 moved from Backlog to In QC, Then moved back to In Progress

When I query it like:

project = "ABC" and status = "In Progress" AND status WAS Backlog ORDER BY created DESC

I get to see my issue ABC-75 in the list

But when I do ,

project = "ABC" and status = "In Progress" AND status WAS "In QC" ORDER BY created DESC, This issue ABC-75 is not showing up

3 answers

Hi @Saloni Goel 

It's a very popular issue to get such data.

I can recommend you to try Time in Status for Jira Cloud and its Status Count and Status Entrance Date reports.

A Status Entrance Date report shows the date when the issue has entered the status for the first time.

statusentrsmcedatereport.png

A Status Count report shows how many times an issue has moved to each status.

Status Count screen .png

You can find more on the documentation page

This add-on is developed by my team and is free for teams up 10 users. Please, let me know if you have any questions.

Hope it helps.

Thanks for replying, I will explore this.

In place of this  "date when the issue has entered the status for the first time."  I need to know date when the issue was transitioned back from UAT, IN QC to In progress again.

But I am still looking out for correct query to do this, without any add-ons., as ours is bigger than 10 users team.

You can try a demo version as well.

Hope it fits your needs.

0 votes
Bloompeak Support Marketplace Partner Jun 24, 2022

Hi @Saloni Goel ,

"status changed" query checks all the transitions, but it matches the direct transitions. That is, if an issue was moved from "IN QC" to "Ready for UAT" and then to "In Progress", the query "status changed from INQC  to InProgress" will not list the issue.

I guess below query should work in your case.

project=ABC AND
(status changed from "IN QC" to "In Progress" OR status changed from "Ready for UAT" to "In Progress")

0 votes

Hello @Saloni Goel

The "status changed" operation checks the whole issue history. You should even be able to use multiple instances of that operator. I mean, the following is a perfectly valid query:

project = "ABC" and status ="In Progress" and (status changed FROM "Backlog" TO "In QC") and (status changed FROM "IN QC" TO "In Progress")

This query translates: Get me the issues

  • That are in ABC project
  • That are currently in "In Progress" status
  • That were transitioned from Backlog to In QC, sometime in their histories. 
  • That were transitioned from In QC to In Progress, sometime in their histories.

Please note that the "status changed" operations are independent. That means it doesn't matter in which order you use them. Each one scans the issue transition history separately.

Hope this makes sense.

 

Using a marketplace app for this will probably make things much easier to report. If you are OK with using a marketplace app for this, our team at OBSS built Time in Status for this exact need. It is available for Jira Server, Cloud, and Data Center.   

Time in Status mainly allows you to see how much time each issue spent on each status and on each assignee. 

tisCloud_StatusDuration_LeadTime_with Estimates.png  tisCloud_AssigneeDuration.png     

The app also has Status Count and Transition Count reports that show how many times each status and each transition was used. This is exactly what you are looking for.

TransitionCount.png  StatusCount.png

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer (organization) or average resolution time per week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) is particularly useful here since it allows you to compare different time periods or see the trend.

tisCloud_StatusDuration_LeadTime_Average_TimeGrouped.png

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. It supports both Company Managed and Team Managed projects.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

And the app has a REST API so you can get the reports from Jira UI or via REST.

Gadget_AverageStatusDurationByComponent.png  tisCloud_StatusDuration_LeadTime_Chart.png

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 issue type.)
  • Export your data as XLS, XLSX, or CSV.
  • Access data via REST API. (for integrations)
  • Visualize data with various chart types.
  • See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/apps/1211756/

EmreT

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,598 views 37 46
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you