Users cannot see certain fields in a list view but can on the form view

[krr]

We are trying to fix an issue where some reference dot-walked fields on a list view or report don't show up, but they do on the form view.

An example off a list view where Program Name (short) is a fields from a reference to Program [pm_program].

If the same user clicks the preview icon, they can see the field.

I've debugged ACLs, but no ACLs are failing for the user. They also pass ACLs for both this table and the Program table.

How do I go about troubleshooting this?

[DScroggins]

Hi we had run into this same issue and it was resolved by adding table level read ACLs to the referenced table. Even though the users have the proper ACLs already for some reason when displaying dot walked fields in a list view the table read ACL needed to exist before the value would be shown. Hope this helps.

[krr]

Thank you for the suggestion on this.

I've tried this by adding read to both the custom table field u_optional_task.u_program and to pm_program.u_program_name_short, but the still can't read it.

I've cleared the server cache and logged out and back in to see if it would help but it didn't unfortunately.

All of the ACLs are reporting access granted, unless I'm reading it wrong.

[DScroggins · Accepted solution]

Do you also add the read ACL to the pm_program table? That's how we had to configure ours when list view wouldn't show all the details.

[krr]

They do have ACL read to pm_program, but it grants them access based on being on the watch list. It appears that is the issue as if I remove this condition, they can see the fields in the list view. So that is the root issue somehow.

It looks like this will need to be restricted by a query business rule unfortunately.