-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.9.2, 7.6.6, 8.5.4, 7.13.13
-
7.06
-
2
-
Severity 2 - Major
-
2
-
Summary
An agile board based on JQL filter like "ORDER BY Rank ASC" returns all issues even with Disable empty JQL queries set to ON.
Note that Where Clause for this filter is Empty, buy OrderBy Clause has data.
Steps to Reproduce
- Turn on the setting Disable empty JQL queries.
- Create a new filter with an JQL query similar to empty "ORDER BY Rank ASC", save it as Empty JQL Filter.
- Create a new scrum project.
- Create some issues in this project.
- Change the board filter to Empty JQL Filter.
- Create a new project.
- Create some issues in this new project.
- Go back to the scrum board created on step #3. Notice how all issues from all projects are displayed in the backlog.
Expected Results
No issues are displayed in the backlog.
Actual Results
Backlog shows all issues in the instance, which can cause an outage due to memory pressure.
Workaround
Use the following SQL to list boards with empty filter:
SELECT * FROM "AO_60DB71_RAPIDVIEW" WHERE "SAVED_FILTER_ID" IN (SELECT id FROM searchrequest WHERE reqcontent like 'ORDER BY%');
- duplicates
-
JSWSERVER-15051 Agile board with empty filter can trigger OOME
- Closed
- is related to
-
JRASERVER-66390 It is extremely easy to save empty JQL filter
- Closed
-
JRASERVER-65602 As an JIRA Administrator I want to make empty JQL return no data
- Closed