Details
-
Bug
-
Resolution: Unresolved
-
High
-
37
-
Severity 2 - Major
-
25
-
Description
Summary
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.
Steps to Reproduce
- Search for issues using a "status was in/was not in (status1, status2) on date" argument;
Expected Results
- All the issues that were on that statuses on that date returns as result of the query.
Actual Results
- 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.
Note: the operators AFTER, ON, and DURING are affected by this. It seems BEFORE works correctly.
Workaround(s)
Currently there is no known workaround for this behavior. A workaround will be added here when available
A previous workaround was available, but this no longer works:
- 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.
- For details you can check: https://community.atlassian.com/t5/Jira-Software-questions/BUG-JQL-Unable-to-query-next-gen-project-s-issues-with-status/qaq-p/1319216#M67818
Attachments
Issue Links
- duplicates
-
JRACLOUD-78540 JQL query search using "status was" returns incorrect unreliable results for Team Managed projects
- Closed
- was cloned as
-
JRACLOUD-78540 JQL query search using "status was" returns incorrect unreliable results for Team Managed projects
- Closed
- causes
-
ACE-4946 Loading...
- is related to
-
JST-507428 Loading...