Column shown blank in list view in spite of having values

RKumar3 · ‎06-26-2014

List view for "task_sla" table is showing "Assignment Group" column blank in spite of having value for assignment group. This occurs only for non admin users. Please refer below screen shots. Any idea why?

RKumar3 · ‎06-27-2014

Hi Mike/ All, I got the root cause of this issue. Please have a look at the link below before I explain why. http://wiki.servicenow.com/index.php?title=Using_Access_Control_Rules#Matching_ACL_Rules_to_Objects

As per this link user should meet the permission for two ACL rules

The first ACL rule that matches the record's field (if any ACL rule exists for the operation).
The first ACL rule that matches the record's table (if any ACL rule exists for the operation).

We met first condition(Mike also tried the same by creating a read rule for assignment group field of task table) but did not met the second condition because we did not have any table level Read ACL for task table(ServiceNow does not provide by default but it provides for other tables e.g. Incident). Hence wildcard table rules (*) ran for all the dot walking on task table fields(task.assignment_group or task.assigned_to).

You guys would have noticed the same issue with the list of approvals where in list view we can not see the assignment group or assignee for the ticket this approval is created for.

TO solve this, I created a new Read ACL on task table and it solved the problem for me.

Regards,

Rajnish

View solution in original post

Mike Moody · ‎03-03-2017

Hi Aarya,

If you are only encountering field data visibility issues for some records, but not others, from the same table, then it's likely that there is an existing ACL in place that is conditionally restricting field visibility to those specific records based on some condition in them that is true. I recommend examining all existing ACLs that apply to that table and tables that it may extend from.