Clarity Service Management

Expand all | Collapse all

Can users with specific grade only access category in casdm?

  • 1.  Can users with specific grade only access category in casdm?

    Posted 08-06-2018 06:58 AM

    Hi All,

     In casdm, can we create a category in such a way that only of specific grade users can raise ticket in this category or simply those users can only see this category? Can we achieve this? or any way in casdm to achieve this?

     

    Thanks in Advance,

    Sushma



  • 2.  Re: Can users with specific grade only access category in casdm?

    Posted 08-06-2018 09:32 AM

    Hi,

    data partition should do the trick:

    Table: Request_Category
    Type: View
    Constraint:
    z_grade <= @cnt.z_grade

    Where z_grade is integer value specified for category and user.



  • 3.  Re: Can users with specific grade only access category in casdm?

    Posted 08-07-2018 04:28 AM

    Please check the snap above, I am applying data constraint over the 'change_category' table on type 'view'.  shown category code should be visible to given contact->positions only.  But at the same time all other categories should be visible to all users.


    Can you please help me to create the correct constraint?



  • 4.  Re: Can users with specific grade only access category in casdm?

    Posted 08-07-2018 08:20 AM

    @-reference can only on value side, ex:

    attr = @cnt.attr

    dont hesitate to publish new attributes when they are really needed, you can simply add z_access_flag to position and category tables and use query like this:

    z_access_flag = @cnt.position.z_access_flag


  • 5.  Re: Can users with specific grade only access category in casdm?

    Posted 08-06-2018 12:32 PM

    if specific grade means a specific role, you can a view type DP for this purpose. Take a look at

    Restrict Categories visibility for users by DataPartition 



  • 6.  Re: Can users with specific grade only access category in casdm?

    Posted 08-07-2018 04:30 AM

    Hi,

     

    specific grade means job_title (or position) not the specific role



  • 7.  Re: Can users with specific grade only access category in casdm?

    Posted 08-07-2018 04:31 AM

    Is there any particular way/syntax for constraints?



  • 8.  Re: Can users with specific grade only access category in casdm?

    Posted 08-07-2018 10:24 AM

    I don't think you can use DP constraints for this as DP is role based not position based.

    I am thinking that one way maybe to modify the hiesel_pcat_xx.htmpl file



  • 9.  Re: Can users with specific grade only access category in casdm?

    Posted 08-10-2018 04:46 AM

    Dear all,

     

     To figure out what you should do. You need to detemine the nature of the access view level .

     

    Means are your contacta categorized (end usrs , hr people , finance, ...etc) if this then I suggest to ctreate a custom table (zcontactCategorry with HR.FINANCE....etc )

     

    Then create one t to many relation between pcat and zcontactCategorry.

     

     

     

    Another approach is to create a one to many relationship between pcat and cnt 

     

    Like groups and members 



  • 10.  Re: Can users with specific grade only access category in casdm?

    Posted 08-10-2018 09:18 AM

    Based on what cdtj told you about @ references, maybe you should try something like :

     

    code <> 'WEBHSTACCS' OR (code = "'WEBHSTACCS' AND (400001 = @cnt.position or 400002 = @cnt.position or 400003 = @cnt.position))



  • 11.  Re: Can users with specific grade only access category in casdm?

    Posted 08-14-2018 01:40 AM

    Thank you for you suggestion, but still it is not working. same error.

    Please check the snap below.  

     

    Can anyone help on this?



  • 12.  Re: Can users with specific grade only access category in casdm?

    Posted 08-14-2018 02:14 AM

    I think that publishing new attr is the only way, please check my comment below: https://communities.ca.com/thread/241813555-can-users-with-specific-grade-only-access-category-in-casdm#comment-24213334… 

     

    To specify valid Data Partition constraint you need to specify:

    1. On the left side - valid, related to current object, attribute that exist in schema. You can check all attrs using bop_sinfo tool. Example: bop_sinfo -a pcat

    2. On the right side should be value OR list of values that matches attr's type. The only way to sepcify a variable is to use user referenced values. Data Partition uses: @root.<attr>, Scoreboard Query uses: @cnt.<attr>. Sorry for the typo I made in my prev messages, you need to use @root reference, not @cnt.