Issues Missing from JQL

Question

I am running the below JQL but for some reason there are 10 issues that are not pulled. I have checked the issues and they all fall in the criteria of the JQL. The only trend that I see in them is that they are all for the last day of April, September, & December.

Any idea what may be wrong in my JQL?

project in (ESD, "EMPLOYERS Service Desk") AND (issuetype = "Service Request with Approvals" OR issuetype = "Service Request") AND "EIG DB Access Type[Dropdown]" in (Temporary) AND status not in (Canceled, Declined) AND resolution not in (Canceled, Duplicate, Declined) AND "EIG DB Temp date[Date]" > 2021-04-01 AND "Request Type" in ("Remove Access (ESD)", "Database Access")

Jesse Ortega Jr · Answer

Thank you Ioana. I have tried this but the 10 issues are still missing. They do have a resolution on them.

Ioana_e7y08v · Answer

Are you expecting to also get tickets that have the resolution Unresolved?

If so, note that resolution not in (Canceled, Duplicate, Declined)  is returning all issues that have a resolution set, that is not any of Canceled, Duplicate, Declined.

This won't return issues that have no resolution. To get that as well, add to your search:

* (resolution not in (Canceled, Duplicate, Declined) OR resolution is EMPTY)
* (resolution not in (Canceled, Duplicate, Declined) OR resolution = Unresolved)

Hope this helps.