Getting an Actor’s Display Name by Logon ID

This function returns actor's (users or groups) formatted display names.

If the actors are a group, only the group account names are returned, and the supplied format string is ignored. If an invalid actor Login ID is supplied, the supplied value is returned.

Syntax

This function has the following syntax:

"OP_ACTOR_MGR.GET_DISPLAY_NAME" (P1, P2, P3, P4)

Where:

Table 1. Function Parameters
Parameter Description
P1 Required. The string value logon user names for the actors (users or groups) to be displayed.
P2 Required. The locale ID (a numeric identifier). Used to automatically translate the text of enumerated strings to the locale of the user running the report.
Note: A value of NULL (without quotes) can be used; however, providing the locale session parameter or locale ID provides the best processing performance. Using NULL will force the function to use the system-wide default locale ID.

To return the session parameter that gives the value of the locale of the user running the report, use the following expression:

#$account.parameters.openPagesLocaleId#

Default: NULL (without quotation marks and not case-sensitive)
P3 Optional. The format display options are:
%FN;
To display the user’s first name.
%LN;
To display the user’s last name.
%EM;
To display the user’s email address.

Default: The logon ID of the actor is displayed if no format is specified.
P4 Optional. Separator for returned display names. Default: A comma followed by a space.

Usage Example 1

The following example displays the first and last name of users who are designated as a Control Owner in the application. Figure 1 shows sample report output.

Figure 1. Control Owner First and Last Name
Crosstab showing first and last names for control owners

Usage Example 2

The following example displays the email of users who are designated as a Control Owner in the application. Figure 2 shows sample report output.

Figure 2. Control Owner Email
Crosstab showing email addresses of control owners

Usage Example 3

The following example displays the first name of users who are designated as a Control Owner in the application. Figure 3 shows sample report output.

Figure 3. Control Owner First Name
Crosstab showing first names of control owners