Forums

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

Query for resolution time range

Ilona Graca November 24, 2022

Hi, 

I have created below query and am receiving no results:

project = Test AND issuetype = Defect AND created >= 2022-08-18 AND created <= 2022-11-02 AND resolved >= 2020-08-18 AND resolved <= 2020-11-02

I am trying to get a list of defects that were created in above mentioned time range and all the defects that were resolved in the time range. My intention is that the unresolved issues stay static so that I can have a comparison on the count of unresolved defects from the previous PI to the current PI. I am not even sure if this is possible as the status of issues are never static.

Thanks!

Regards

Ilona

2 answers

1 accepted

0 votes
Answer accepted
Trudy Claspill
Community Champion
November 24, 2022

Your current query will return only issues that were BOTH created AND resolved in the date ranges you specified.

Is that what you want?

Or do you want a list of issues created in the date range combined with the list of issues resolved in the date range but created on any date? @Mohamed Benziane 's answer gives you this result.

0 votes
Mohamed Benziane
Community Champion
November 24, 2022

Hi,

You should try comthing like this:

(project = Test AND issuetype = Defect AND created >= 2022-08-18 AND created <= 2022-11-02) or (project = Test and resolved >= 2020-08-18 AND resolved <= 2020-11-02)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events