JQL query to get unresolved bugs on some date.

Misha_w52grs

Hi, I'm trying to get issues with type bug, that was open on some date. I don't want to relay on the status field, because it can change, so I decided to use resolution field instead.

I created the query:

issuetype = "Bug" and resolution WAS empty ON "2020-06-16" //(today)

but it selects only around 30 issues in my project, while the query, that should do the same for today:

issuetype = "Bug" and resolution is empty

selects 400+ issues, and that's correct.

I checked the issues from the first query, and looks like that query only selects the issues, for which resolution field was changed back to empty (kind of reopened issues), and don't select issues for which resolution field was initially empty (just open issues).

So, the question is how to correctly get the issues with empty resolution field on some date.

Misha_w52grs

For those, who are looking for a solution of that issue, i found the alternative way of getting unresolved bugs on some date, but it's a little bit more complicated, and uses resolutiondate field. Here is the query:

issuetype = "Bug" and (created <= "2020-06-16") and (resolutiondate >= "2020-06-16" or resolution = unresolved)

 Looks like that query is working fine for that case, but, anyway, if somebody knows why the history search query is not woking like expected, or knows how to make it working, please let me know.