Limit group insights query in a subset of projects

What does this MR do?

Limit group insights query in a subset of projects

Screenshots

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation created/updated or follow-up review issue created

Performance and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.

Closes #10904 (closed)