Actions
Bug #29447
closedFilter 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)
Actions