User functions

currentUser()

It returns the Jira currentUser.

Example:

 

select currentUser() as “CurrentUser” from dual

 

CurrentUser

CurrentUser

admin

 

usernameKey(String)

 

It returns the username from the user key.


Example:

 

select usernameKey('JIRAUSER00001') as “Username” from dual

 

Username

Username

johnsmith

 

usernameDisplay(String)

It returns the full user’s name from the username.


Example:

 

select usernameKey('admin') as “Username Display” from dual

 

Username Display

Username Display

John Smith