User functions
currentUser()
It returns the Jira currentUser.
Example:
select currentUser() as “CurrentUser” from dual
CurrentUser |
|---|
admin |
usernameKey(String)
It returns the username from the user key.
Example:
select usernameKey('JIRAUSER00001') as “Username” from dual
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 |
|---|
John Smith |