Redmine

When filtering issues by "Assignee's group" or "Author's group", IssueQuery fetches the members of each group with a separate SQL query.

With the "any" or "none" operators, all groups are iterated, so the number of queries grows with the number of groups in the Redmine instance. For example, building the filter condition on a system with 100 groups executes 100 queries.

The attached patch fetches the members of all groups with a single query, using the same subquery style as the existing User.in_group scope. The generated where clause is unchanged.