We display the groups a user belongs to in a read-only grid, and the data appears correctly in the UI. However, when a basic user exports the data using the default record export, the group names are not visible in the exported file.
Discussion posts and replies are publicly visible
a!gridField( data: a!recordData( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', filters: a!queryLogicalExpression( operator: "AND", ignoreFiltersWithEmptyValues: true, logicalExpressions: { a!queryLogicalExpression( operator: "AND", ignoreFiltersWithEmptyValues: true, filters: { a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_isServiceAccount}isServiceAccount', operator: "=", value: false ), a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active', operator: "=", value: local!status, applyWhen: a!isNotNullOrEmpty(local!status) ) } ), a!queryLogicalExpression( operator: "OR", ignoreFiltersWithEmptyValues: true, filters: { a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName}firstAndLastName', operator: "includes", value: local!searchText, applyWhen: a!isNotNullOrEmpty(local!searchText) ), a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_email}email', operator: "includes", value: local!searchText, applyWhen: a!isNotNullOrEmpty(local!searchText) ) } ) } ), fields: { 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_uuid}uuid', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstName}firstName', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_lastName}lastName', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_email}email', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName}firstAndLastName', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.relationships.{b091aaa6-27e4-406a-8b2f-1a658699f5eb}employeeRoster' } ), columns: { a!gridColumn( label: "Full Name", sortField: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName}firstAndLastName', value: fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName}firstAndLastName'] ), a!gridColumn( label: "Email", sortField: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_email}email', value: fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_email}email'] ), a!gridColumn( label: "User Group", value: if( toboolean( fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active'] ) <> true(), "Deactivated User Account", a!localVariables( local!groupsOfCurrentUser: if( fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username'] = "serviceAccount", null, a!groupsForUser( username: touser( fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username'] ) ) ), local!directMemeberGroups: a!forEach( items: local!groupsOfCurrentUser, expression: a!localVariables( local!directMembers: a!groupMembers( group: fv!item, direct: true, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5000) ).data, if( and( not(rule!APN_isEmpty(local!directMembers)), contains( touser(local!directMembers), touser( fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username'] ) ) ), togroup(fv!item), {} ) ) ), local!groupNamesAll: a!flatten( a!forEach( items: local!directMemeberGroups, expression: if( rule!IHUB_CheckNullValue(value: fv!item), "ServiceAcc", group(fv!item, "groupName") ) ) ), local!allIhubGroups: a!flatten( index( local!groupNamesAll, wherecontains( {lower("IHUB"),lower("Otsu")}, lower( a!forEach( items: local!groupNamesAll, expression: left(fv!item, 4) ) ) ), null ) ), local!removeNonBusiIhubGroups: remove( local!allIhubGroups, wherecontains( cons!IHUB_TEXT_GROUP_NAMES_TO_BE_REMOVED_FROM_USER_REPORTS, touniformstring(local!allIhubGroups) ) ), joinarray( reject( fn!isnull, local!removeNonBusiIhubGroups ), ", " ) ) ) ), a!gridColumn( label: "License Status", value: if( fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active'], "Active", "Inactive" ) ), /*a!gridColumn(*/ /*label: "Update Action",*/ /*value: a!recordActionField(*/ /*actions: a!recordActionItem(*/ /*identifier:fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_uuid}uuid'],*/ /*action: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.actions.{bfe563cb-239b-488f-bca0-e60998dcd8c2}'*/ /*),*/ /*style: "TOOLBAR_PRIMARY",*/ /*display: "ICON",*/ /*showWhen: a!defaultValue(fv!row['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active'],false())*/ /*),*/ /*align: "CENTER"*/ /*)*/ }, pageSize: 10, borderStyle: "STANDARD", selectable: true, selectionValue: local!selectedUsers, selectionSaveInto: { local!selectedUsers, a!save( local!selectedRows, append(local!selectedRows, fv!selectedRows) ), a!save( local!selectedRows, difference(local!selectedRows, fv!deselectedRows) ) }, initialSorts: { a!sortInfo( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_uuid}uuid', ascending: false ) }, showSearchBox: true, showExportButton: true, userFilters: { 'recordType!{SYSTEM_RECORD_TYPE_USER}User.filters.{0b983a21-a3a8-4725-843c-52f594a381c9}statusForGrid' }, recordActions: a!recordActionItem( action: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.actions.{00380692-8c5f-4b5e-ae32-65833cced2a3}createUser' ), actionsStyle: "TOOLBAR_PRIMARY", refreshAfter: "RECORD_ACTION", refreshOnVarChange: local!refresh, refreshOnReferencedVarChange: true ),