Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,551,671
Community Members
 
Community Events
184
Community Groups

Need to find issues that moved from one status to another

I need to understand what % of our issues are getting deployed without moving through our QA process. Ideally, an issue status goes from In Progress to QA Ready to QA Started to QA Complete before being changed to Merged and then Deployed. Issues that bypass our QA Process will go straight from In Progress to Merged and then Deployed.

What would the syntax be for identifying recently resolved issues (say, in the last month) that moved through our QA statuses?

 

1 answer

1 accepted

1 vote
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 26, 2019

Hi Becky - Welcome to the Community!

You can do the query as you want for the list of issues that are resolved (for whatever time period you want) and then add "and status was in ("QA Complete") or whichever of the statuses you want to identify. Usually in the case you have identified, I use status was not in ("QA Complete") which shows the issues that did NOT go through QA Complete. 

So it would look something like this, status changed to Resolved during (yyyy-mm-dd, yyyy-mm-dd) and status was not in ("QA Complete"). 

Where Resolved is the actual status name you use and the dates are the time frame you are looking for. 

Hope that helps. If you have trouble with the syntax, holler back.  :-)

Wow thank you @John Funk that's exactly what I needed. Turns out that these queries did the job:

status changed to "deployed" during (2019-01-01, 2019-03-25) and status was in ("QA Complete") and project = Product

comparing to 

status changed to "deployed" during (2019-01-01, 2019-03-25) and status was not in ("QA Complete") and project = Product

To understand what % is making it thru the process. 

 

Thank you!

Like JAVIERA VEGA likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 26, 2019

Great! Can you click on Accept Answer for me?

I wasn't able to pull resultant even if the syntax and other seems to correct. 

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 24, 2023

Hi Devi - Please create a separate question and provide the details of what you need. That way more people will see it. You can tag me on it if you like.

Like Devi Vaishnavie likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events