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.
I'm not sure you'll be able to accomplish this with a data partition constraint. I'd recommend taking a look at this Communities post:
Data partitions with @root attributes
It's not exactly the same situation as what you're dealing with, but the concept is very similar.
That thread is not helped to my requirement. Can you/anybody please suggest some ideas to get this achieved?
I'm sorry the example in that thread didn't help. It is going to require a certain level of spel code customization, and I'm not able to provide any more specific examples.
Does anybody else out there have any ideas?
@root.location.zRegion = customer.location.zRegion
Thanks for your reply.
@root.location.zRegion = customer.location.zRegion is not working.
Because, zRegion is on cnt. Not on Location object.
Please help on this
Hi saravana.kumbalingam.1 - Did Gutis's response help answer your question? If so please mark as Correct Answer. Thanks!
If it does not depends on User1 location or any other attribute than
customer.zRegion = '2000'
if this depends on User1 location than you need have separate roles for each location