Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Fixed Status Bugs Not Returning Accurate Results

r2d2 February 8, 2023

Struggling to identify defects that have been fixed in a particular time period.

Please see jql query used:

project = test AND issuetype = Bug AND status was 'Fixed'

 

Can a additional parameter be added to narrow the date down? is there anything that helps narrow the date e.g. status date?

2 answers

2 accepted

2 votes
Answer accepted
Trudy Claspill
Community Champion
February 8, 2023

Hello @r2d2 

You can use the CHANGED operator to filter for issues where the status was changed to a particular value before, after, or during a time period. Refer to:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

1 vote
Answer accepted
Esther Strom
Community Champion
February 8, 2023

When you use the "WAS" operator in JQL, that's going to show you any ticket that was ever in that status. If you're looking for any ticket that had its status changed to Fixed within a date range, you can do something like this, as shown in @Petter Gonçalves update on this post

  1. Using Dynamic date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between five and two weeks before my current time:

    status changed to closed after -5w before -2w

  2. Using Static date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between “08/01/2020 00:00” and “09/15/2020 00:00”:

    status changed to closed after "2020/08/01 00:00" before "2020/09/15 00:00”

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events