JQL query for creation date range and resolution date range

[Ilona Graca]

Hi,

I would like to have an overview of all issue types defects created in a specific date range and were resolved in a specific date range.

When using this query I don`t receive any 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

Does anyone have an idea what is incorrect with my query?

Thanks!

Regards

Ilona

[Walter Buggenhout · Accepted solution]

Hi @Ilona Graca and welcome to the Community!

With the exact query you shared in your question, you seem to be searching for issues that were created in 2022 and resolved in 2020. That is probably a typo. Issues get resolved after they are created, so it is quite normal that your query does not return any results.

Hope this helps!

[Ilona Graca]

oops, thats right! Thanks for pointing that out!

[Marta Woźniak-Semeniuk · Accepted solution]

You don't get any results or you get a query error? 

The query itself is a correct one - if you have any issues in the test project that matches the criteria, it should show.

Things I would check

* is it a correct issue type 
* are the there any resolved issues? maybe they are in status resolved, but the resolution was not really set - hence there is no resolution date to check?

[Ilona Graca]

I had a typo in the date, that`s the reason I didn`t get any results...stupid me;)