Restrict Categories visibility for users by DataPartition

[Aamir Khan]

Hi Team

We need to show some Categories/Request Areas to the specific users only and not to show every users. For this, we have created DataPartition and write constraint as ' sym like 'VMware' ' and define this DP in User contact. But when the user login and select category, still showing all . Please help to write correct constraint

 

Following snapshot highlighted one we need to visible only.

 

 

 

 

 

[Legacy User]

Hi,

 

attr like 'value'

means exact match, you forgot to add wildcard, so correct one would be:

attr like 'value%'

 

Publishing kind of access flag could be a better way to limit category usage:

// schema
z_access_flag {
     ON_NEW DEFAULT 0;
}

// data partition constraint
z_access_flag = 0 OR z_access_flag is NULL

[Aamir Khan]

hi cdtj

 

I dont get u

 

according to below link it seems simple constraint to apply

 

http://www.servicedeskusers.com/Data_Partitions. 

 

 

prob_ctg	View	sym like 'Application'	Display only the Application Areas

 

 

 

But its not working.

[Chi Chen]

"sym like 'Application'" view on prob_category should show Application area only.

If that is not the case for you, please make sure the logged in user does have this DP applied...DP is role based/contact based combined depending on the setup like "Override Contact Data Partition? on the role detail.

[Aamir Khan]

Hi Chi Chen

 

Thanks for your reply

 

the following constraint in DataPartition is fulfilling my need. I am now able to see only this category ' Virtual Cloud Director.'

sym like 'Virtual Cloud Director%' .

 

I have set data partition on on each user and it showing only this Category. 

I have unchecked 'Override Contact Data Partition' in employee role so now my DP is working on employee user.

 

However as i said in my post with screenshot, 3 highlighted categories i need to show only.

if i modify constraint like below it saying bad clause. Please correct me. 

 

wt to replace instead of &&?

 

sym like 'Virtual Cloud Director%' && 'Hyper V%' && 'VMware%'

 

[Chi Chen]

you can try

sym IN ('Virtual Cloud Director%', 'Hyper V%', 'VMware%')

[Aamir Khan]

Hi Chichen

 

Im able to save this constraint but when end user login n select category, nothing is showing there.

Please note these categories are for Request and incident both.

[Chi Chen]

sorry, it should be

(sym like 'Virtual Cloud Director%') OR (sym like 'Hyper V%') OR (sym like 'VMware%')

[Aamir Khan]

Perfect ChiChen

 

Many Thanks. It works for me (Y)