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
Can you share a sample expression for the landing page you are trying to show?
Something like this..
with( local!cdt: rule!getData(), a!gridLayout( labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell( label: "ID" ), a!gridLayoutHeaderCell( label: "Status" ), a!gridLayoutHeaderCell( label: "Assigned To" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig() }, rows: { a!forEach( items: index( local!cdt, "data", {} ), expression: a!gridRowLayout( selectionDisabled: true, contents: { /*Id*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.Id, link: a!recordLink( identifier: fv!item.Id, recordType: "recordtype" ), linkStyle: "STANDALONE" ) ), /* Status*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.status ) ), /* Assigned To*/ a!richTextDisplayField( value: a!richTextItem( text: joinarray( { user( fv!item.assignedTo, "firstName" ), user( fv!item.assignedTo, "lastName" ) }, " " ) ) ) } ) ) }, emptyGridMessage: "No records" ))
Expression looks fine - I think the issue is what Mike suggested below.