Actions
Bug #29447
closed
Filter builds taxonomy search filter inefficiently
Status:
Closed
Priority:
Normal
Assignee:
Category:
Users, Roles and Permissions
Target version:
-
Description
If a filter supports taxonomy filtering and the role has many taxonomies assigned then the resulting search query could look like
(organization_id = 1 OR organization_id = 2 OR organization_id = 3) AND (location_id = 1 or location_id = 2)
However scoped search support using the IN operator, so we could get a more compact query, something along the lines of
organization_id ^ (1,2,3) AND location_id ^ (1,2)
Updated by The Foreman Bot about 4 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/7553 added
Updated by Anonymous about 4 years ago
- Blocked by Refactor #29532: Update scoped_search to 4.1.8 added
Updated by Tomer Brisker about 4 years ago
- Category set to Users, Roles and Permissions
Updated by Adam Ruzicka about 4 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset 72209166fa58d3c5bc2b3629d98696edf7bd7250.
Updated by Ondřej Ezr over 3 years ago
- Related to Bug #30797: Postgres usage spikes and disk space completely filled up, when non-admin select Monitor -> Tasks added
Updated by Ondřej Ezr over 3 years ago
- Related to Bug #30847: Filters needs to rebuild the taxonomy_search added
Actions