Clarity Service Management

Expand all | Collapse all

Restrict Categories visibility for users by DataPartition

Jump to Best Answer
  • 1.  Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 06:24 AM

    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.

     

     

     

     

     



  • 2.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 09:41 AM

    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


  • 3.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 11:59 AM

    hi cdtj

     

    I dont get u

     

    according to below link it seems simple constraint to apply

     

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

     

     

    prob_ctgViewsym like 'Application'

    Display only the Application Areas

     

     

     

    But its not working.



  • 4.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 12:12 PM

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



  • 5.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 02:32 PM

    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%'

     



  • 6.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 02:41 PM

    you can try

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



  • 7.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 02:50 PM

    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.



  • 8.  Re: Restrict Categories visibility for users by DataPartition
    Best Answer

    Posted 08-06-2018 03:01 PM

    sorry, it should be

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



  • 9.  Re: Restrict Categories visibility for users by DataPartition

    Posted 08-06-2018 03:11 PM

    Perfect ChiChen

     

    Many Thanks. It works for me (Y)