Urgent !!! CSM Query rule issue

[manita1]

CSM Query rule not working as expected.

requirement 1: to show only those health cases for users that they opened , these users are basically members

requirment 2: To show cases to Managers opened by their department. 

ibhad read acls before on the case type table but customer wants user experience with CSM query rules where they don’t have to see security constraint message on the portal or workspace.

then I tried CSM query rules where, first one worked with on before business rule to only show users with cases opened by them but second one needs help. 
I want logged in user manager department and then query all cases for that department and only show those .

[JackieZhang]

I suggest to use before query instead of using CSM query rule. 

[manita1 · Accepted solution]

I made this working by disabling OOB  query rules at parent table level !