Business Rule: Account query rules

[vidhya_mouli]

I have a widget which is trying to read the child accounts when the user is mentioned in the Customer User Relationships (sn_customerservice_contact_relationship). But because of Business Rule: Account query rules, user is not getting access to the child accounts.

I wrote the following script (with a dummy filter condition) to test my theory and the user is now able to access the child accounts. 

However, the filter condition gives them access to all the child accounts. I don't want that to happen. User should have access only to those where he is mentioned in the Customer User Relationships. 

What filter condition should I write for this?

[Mark Manders]

Since the customer user relationship is a different table, you can't directly access it from there. You will need to update the Account query rules to allow this.

[vidhya_mouli · Accepted solution]

Manged to create a new Query which resolved my issue