Please understand clearly
I want to create Data partition for the below requirement
1. I have a user 'User1' assigned to location='location1'
2. I have a user 'location1' assigned to zRegion='2000'
I want: If the User1 logged into SDM, he has to see the tickets only which are having Affected end user's zRegion='2000'
User1 is assigned to location =location1
location1 user is assigned to zRegion='2000'
location2 user is assigned to zRegion='2000'
location3 user is assigned to zRegion='2001'
location4 user is assigned to zRegion='2002'
If User1 is logged in, he has to see the tickets only which are containing Affected end user's zRegion='2000' (two tickets)
* zRegion is on cnt as String type.
* location1, location2, location3 users are having contact type as 'Store
* User1 is assigned to location=location1 in location table.
Please help on this. Thanks in advance.