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

JQL to find bugs set to Ready for QA within a specified date and time range

The Product Owner wants to able to identify which Jiras were set to Ready for QA on a date in the past. this has come about because we discovered something unexpected had broken. It was discovered a few days later and she wants a  filter that allows us to find any Jira set to DONE/READY for QA on a particular day before the deployment time of 11pm.

I can find DONE for any date using:

project = projectname AND issuetype = Bug AND status in (Done, "Ready for QA") AND updated >= Date1 AND updated <= Date2 order by created DESC

It’s not picking up “Ready for QA” - I assume this is because the last Updated Date is the one which is when the tester set it to Done. However, I would have thought that anything being set by the Devs as Ready for QA would get picked up.

I suspect there is no way to find bugs set to Ready for QA within a specified date AND time range but thought I'd ask.

 

1 answer

1 accepted

2 votes
Answer accepted

Hi @Karen Bayly

This is possible using history searches, which work for a small number of fields including status. In your instance, something like this should work:

status was "Ready for QA" DURING ("2019-09-15 00:00","2019-09-17 23:00") and project = ABC and issuetype = Bug

^ There are other things you can do - such as looking for issues changed into or out of "Ready for QA" in a time range - you can see more details on this article.

For Done - consider using resolved date rather than updated date. Unless you have restricted editing via status properties, you can still update an issue once its closed.

Ste

Thanks. That worked a treat.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Jira Cloud for Google Sheets: Automatically Refresh Your Data!

Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...

483 views 3 11
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