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

RKumar3 · ‎06-26-2014

Yes I already checked and there is only one assignment group field. I also checked if there is any ACL but nothing is there in ACL list which can cause this. Rajnish

Subhajit1 · ‎06-26-2014

You said that this is the Task_SLA table, right. You are populating the Field on the Incident table.

This assignment group field is on the Task_SLA table which is actually not getting poplulated.

That, i think is the issue.

OR

There might be a ACL on the Assignment Group field of the Task SLA table that denies Read Access

Thanks,

Subhajit

RKumar3 · ‎06-26-2014

Hi Subhajit, There is not other field "Assignment Group" on task_sla table. I am showing the field from task table only. This is also proved from the fact that I can see values in this field if I am an admin. I checked all ACLs as well and there is no ACL that would restrict this column to populate. Rajnish

Mike Moody · ‎06-26-2014

Hi Rajnish,

Is it the caller on the incident that you are trying to give this "Assignment Group" visibility to via the task_sla table?

Mike

RKumar3 · ‎06-26-2014

Hi Mike, I am trying to give "Assignment Group" column visibility to all the users via task_sla table. Rajnish