I am working on creating data partition constraints. Recently I created a constraint in which I restricted the ticket view based on the location of customer using the following query:
After this, the user is able to see the tickets where the location of customer is same as user.
It is working fine.
Now I want to create the constraint in which the user is able to see the tickets belonging to all the locations of customers in his site.
What will be the query for this constraint? Kindly suggest.
Thanks & Regards,
Balram Singh Deswal