Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

USER_NAME

Applies to: CELONIS 4.5 CELONIS 4.6

Description

Returns the Celonis username of the current user.

Syntax
USER_NAME()
Examples

[1] This example shows the output of the USER_NAME function executed by the user Test User.

Query

Column1

USER_NAME ( )

Input

Output

Result

Column1 : STRING

'Test User'

[2] In this example, only the user Permitted User is allowed to see the value column of the example table. All other users will only see NULL values in this column. This example shows the output when it is executed by the user Test User, who is not allowed to see the value column.

Query

Column1

"CaseTable"."companyCode"

Column2

CASE WHEN USER_NAME ( ) = 'Permitted User' THEN "CaseTable"."value" ELSE NULL END

Input

Output

CaseTable

caseId : INT

companyCode : STRING

value : INT

1

'001'

600

2

'001'

400

3

'001'

200

4

'002'

300

5

'002'

300

6

'003'

200

Result

Column1 : STRING

Column2 : INT

'001'

null

'001'

null

'001'

null

'002'

null

'002'

null

'003'

null