41 views

Description

This is a known error for releases prior to Jakarta Patch 6. 

When the Customer Service (com.sn_customerservice) plugin is loaded, it additionally loads a plugin called Customer Service Base Entries (com.snc.cs_base) which contains a restrictive read ACL on sys_user.sys_id. This ACL prevents users from querying the sys_user table by sys_id, which the slushbucket does for the Member drop-down list on the Manage Rota form. 

Steps to Reproduce

 

  1. Activate the On-Call Scheduling (com.snc.on_call_rotation) plugin if not activated.

  2. Navigate to On-Call Scheduling > On-Call Calendars.

  3. Select a group.

  4. Right-click the group and select Manage Rota.

  5. In the Manage Rota form, click the Member drop-down list.

    Note that Members are not visible and the Member field displays No matches found, as in the following example. 

    After the fix or workaround is applied, you should see multiple group members in the Member drop-down list.

     

 

Workaround

 

  1. Go to the sys_security_acl table and search entries by name: *sys_user.sys_id.

  2. Add the snc_internal role in the Requires Role tab.

  3. In the Script field, edit the script as follows:

    if (gs.hasRole('snc_internal'))
      answer = true;
    else if (gs.getUserID() == current.sys_id)
      answer = true;
    else
      answer = false;

Related Problem: PRB1021742

Seen In

Istanbul Patch 3

Fixed In

Jakarta Patch 6
Kingston

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-05-24 14:32:31
Published:2018-05-24