user( username, property )
Returns information for a user.
Keyword | Type | Description |
---|---|---|
|
Text |
The username or user object of the user whose information should be retrieved. |
|
Text |
The information to retrieve for this user. See Usage considerations. |
Text
The property parameter accepts the following (case-sensitive) values:
Note: locale
and timeZone
return the user's preference or null if not set.
The user()
function can only return information about a single user. If you need to return information about multiple users, you should use the a!queryRecordType() function to query the User record type.
For example, you could use the user()
function to display a user's first and last name. But, if you want to display the first and last name of all active users, you would use the following expression:
1
2
3
4
5
6
7
8
9
10
a!queryRecordType(
recordType: recordType!User,
fields: recordType!User.fields.firstAndLastName,
filters: a!queryFilter(
field: recordType!User.fields.active,
operator: "=",
value: true
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data
Returns
1
2
3
4
Jane Doe
John Smith
Sam Jones
William Doe
Learn more about referencing data from the User record type
The following examples use a sample record type called Employee
. These expressions illustrate how to display data in a record list, which is why they uses the fv!
domain prefix.
Record type object references are specific to each environment. If you copy and paste these examples into your interface, they will not evaluate. Use them as a references only.
1
user(username: fv!row[recordType!Employee.fields.username], property: "firstName") & " " & user(username: fv!row[recordType!Employee.fields.username], property: "lastName")
Returns
Jane Doe
1
user(username: fv!row[recordType!Employee.fields.username], property: "created")
Returns
12/20/22 10:36 PM GMT
1
user(username: fv!row[recordType!Employee.fields.username], property: "email")
Returns
jane.doe@example.com
Feature | Compatibility | Note |
---|---|---|
Portals | Partially compatible | Can be used with Appian Portals if it is connected using an integration and web API. |
Offline Mobile | Partially compatible | Can be used with offline mobile if it is loaded at the top of the form. |
Sync-Time Custom Record Fields | Incompatible | |
Real-Time Custom Record Fields | Incompatible | |
Process Reports | Compatible | |
Process Events | Compatible |
user() Function