CA Service Management

Expand all | Collapse all

Data Partition Help on SDM

  • 1.  Data Partition Help on SDM

    Posted 06-22-2016 03:57 PM

    Hi,

     

    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'

     

    Example:

    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)

     

    Note:

    * 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.



  • 2.  Re: Data Partition Help on SDM

    Broadcom Employee
    Posted 06-23-2016 01:56 PM

    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.



  • 3.  Re: Data Partition Help on SDM

    Posted 06-28-2016 09:20 AM

    Hi Alexandar,

     

    That thread is not helped to my requirement. Can you/anybody please suggest some ideas to get this achieved?

     

    Thanks



  • 4.  Re: Data Partition Help on SDM

    Posted 06-30-2016 01:40 AM

    @root.location.zRegion = customer.location.zRegion



  • 5.  Re: Data Partition Help on SDM

    Broadcom Employee
    Posted 06-28-2016 09:26 AM

    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?



  • 6.  Re: Data Partition Help on SDM

    Posted 06-30-2016 04:41 AM

    Hi Gutis,

    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

     

    -Thanks



  • 7.  Re: Data Partition Help on SDM

    Posted 06-30-2016 05:01 AM

    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



  • 8.  Re: Data Partition Help on SDM

    Former Employee
    Posted 07-05-2016 04:28 PM

    Hi saravana.kumbalingam.1 - Did Gutis's response help answer your question? If so please mark as Correct Answer. Thanks!