• I have 2 tables, called Users and UserGroups.
• The Users table has a global filter to only return users with a Status of 'Active'.
• The UserGroups table has a global filter to only return groups with an Owner who is 'Active'.

If I want to return a list of active users with their associated user groups, this works fine.

Now I want to return the list of all users, including the groups they belong to, so I add .IgnoreQueryFilters() to my query, and this works, but it also returns the user groups where the Owner is 'Inactive'. So I have to manually add the UserGroup filtering back into my query, and if the global filter ever changes, I have to add that change manually to this query.

Is there a way to override the filters on Users, but not the filters on UserGroups?