Can't see data on list view but can see it in form view within Service Portal Data Table widget

Oliver Anderson · ‎09-28-2023

I have a Data Table from Instance Definition widget on a page in the Service Portal. The widget is pointed to table 'cmdb_ci_business_app' and should show all users, regardless of roles, the fields selected in list view. I'm seeing an issue where users without admin role are unable to see 2 of the fields on 'cmdb_ci_business_app', but if they click into a record in the table, they CAN see the two fields on the form view.

Missing data under Manufacturer and Support vendor in list view:

Visible data under Manufacturer and Support Vendor in form view (Support Vendor just happens to actually be empty in this record):

Again, as a user with admin role I can see data in the list view of the widget just fine.

We have 0 read ACLs on 'cmdb_ci_business_app', the dictionary entries of Manufacturer and Support Vendor, and the 'core_company' table, so I'm fairly certain it's not an ACL thing unless I'm missing one somewhere. Others have suggested that Client Scripts populating data on forms will not populate the DB that the list view is pulling from, but we don't have any Client Scripts on this table relating to Manufacturer or Support Vendor, so that is not the case here.

Any help would be greatly appreciated!

Satyapriya · ‎09-28-2023

Hi @Oliver Anderson,

This might be due to ACL i.e Add to list ACL on the cmdb_ci_business_app.

If this exists then that will prevent to view fields on lists.

Please check that ACL.

Oliver Anderson · ‎09-29-2023

There are no Add to list ACLs on the table. The only ACLs we have at the table level are Create and Delete ACLs restricting these actions to admins.

We do have write ACLs on manufacturer and support vendor restricting write permissions to admins, but there is nothing list or read related.

Oliver Anderson · ‎10-10-2023

I have debugged ACLs and standard users are passing all READ ACLs for manufacturer and support_vendor. Anybody have other ideas? Furthermore, users can see the data in the list within the agent portal, just not on this widget in the Service Portal.