JQL query for creation date range and resolution date range

Question

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

Marta Woźniak-Semeniuk_m044pw · Accepted Answer

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?

Walter Buggenhout · Accepted Answer

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!