Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

I want to filter Completed-Stories (Done) which were failed by QA or UAT before completion.

Hello Everyone, 

We are wondering to create a report for previous-sprint stories which were 'DONE' but failed QA or UAT before that, report may include comments of the stakeholder who failed it.

We want to analyze any patterns or other reasons for failing to improve our process.

Thanks for your time and advice in advance,



1 answer

1 accepted

3 votes
Answer accepted
John Funk Community Leader Jun 01, 2021

Hi Muhammad,

How did you notate that the story had failed QA or UAT? Was there a value set in a field? Or was it moved to a different status? 

Hi John,

Yes, it was moved from QA status to Failed status, with some notes in the comments.

Thanks for looking into it.

John Funk Community Leader Jun 01, 2021

Great - thank you for the updated information. Maybe try a JQL like:

project = ABC AND status = Done and status was in ("Failed") during (2021-05-01, 2021-05-31)

You don't have to include the during and dates at the end. I just thought it would help if you had that requirement. 

I will try and update my experience here.


Like John Funk likes this

Hi John,

I am a beginner in JIRA, tried some places to input the above query but I could not get to the right place. Would you mind sharing a screenshot?

Thank you.

John Funk Community Leader Jun 03, 2021

Click on the Search box in the top navigation bar


Then click on Advanced Issue Search

Then click on Switch to JQL


Then paste the query above in. Change the project and any date information to be for what you need and click on Search.


Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

167 views 6 7
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