Improve Event Query Performance with Complex Permission Configuration

[adam-mccoy]

Prerequisites

• [x] I have searched open and closed issues to make sure it isn't already requested
• [x] My team has started working on this issue
• [x] I have written a descriptive issue title

The enhancement

The Need

Searching for events when users have a complex scoped permission setup can generate very complex database queries. This results in poor performance of these searches.

Solution

Implement a new permission filter for events with better performance.

Links

Target Architecture (internal)

[octoreleasebot]

Release Note: Improve permission query filter performance for events

[Octobob]

:tada: The fix for this issue has been released in:

Release stream	Release
2024.4	2024.4.6141
2025.1+	all releases