CA Service Management

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

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.

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?

@-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

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 

Hi,

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

Is there any particular way/syntax for constraints?

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

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 

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))

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

Please check the snap below.  

Can anyone help on this?

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.