We have a site with a record list on a report (No Process model) as Landing page(Home). The grid has a column called "Assigned To". The data is coming from DB as Appian usernames. I am trying to display user friendly name such as first and last name (Through user() function). This works well for a Sys admin user. But when a basic user logs in he can only see his own display name but not others. For others he only sees their username.
I need a way to display full name with a basic user login.
Here is some background.
We are appian version 19.4
All related groups have appropriate security setup, with public visibility, and low privacy policy.
Discussion posts and replies are publicly visible