How to make other users' profile information (e.g., first name and last name) visible to a basic user on a report

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.

Default User Profile Visibility (Checked in admin console)
Users can see the profile details of all users by default

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data