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

AnishSasidharan · ‎06-26-2014

Hi Kumar,

Have you checked the assignment groups are getting populated in onload of your incident form ?

If that is the case, then assignment groups are not yet saved in the incident table. So it show blank value in the list view.

Subhajit1 · ‎06-26-2014

Hi,

This can be a Issue of not having Read Access of the Assignment Group Field on the List View.

For that you might want to check your ACLs on the list view.

Thanks,

Subhajit

RKumar3 · ‎06-26-2014

Read access is there for users as they can edit the field on the form.

harikrish_v · ‎06-26-2014

Hi Rajnish,

You must have done this already, but just check the layout if it is the same field on the list layout that you are referring to in the form layout. There might be another Assignment Group on the table.

If this is not the case, then you might want to check if there are any read ACL's on that field restricting access for the end user to this field. Also check onload client scripts, display business rules etc to see if the value is actually getting saved in the back-end or just populated in the UI via those. Just try to output this value in an after-update BRule just to be sure.

Thanks & Regards,

Hari