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?
@root.location.zRegion = customer.location.zRegion
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?
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
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
Hi saravana.kumbalingam.1 - Did Gutis's response help answer your question? If so please mark as Correct Answer. Thanks!