When searching for issues using a "status" statements ("status was", "status =", "status changed"), the results are unreliable. This happens if there is a Next-gen project in the Jira's Cloud instance.
- Search for issues using a "status was in/was not in (status1, status2) on date" argument;
- All the issues that were on that statuses on that date returns as result of the query.
- Some issues show in the result of the query. Other that also matches the argument, don't.
Update on April the 17th, 2020!
This problem is very consistent on issues that are imported through a .CSV file and are on a different status than the query.
- Jira admins can leverage the REST API GET /rest/api/2/status against their Cloud instances to retrieve the ID of the statuses and then use it in JQL queries;
- Update on April the 17th, 2020! The workaround above seems to not be working.
- To retrieve the ID of statuses used by Classic projects, Jira admins can also type the g key twice on their keyboard (gg) or, as alternative, their period key ( . ), then Statuses, hover the mouse over the "Edit" option on the relevant status and write down the number shown in the end of the URL.