user visibility issue

Question

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.

thammireddyb962647 · Answer

    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
              ),

Sign up

Login with SSO

Login to the community

Login with SSO