BBC.SHARED.VARA@SEC_SQLI.GET-EMAIL-ADDRESS
Summary
Description
Retrieves the first email address of the current user
Input
Only system variables are required as input
- Object type
- VARA
- Object Folder
- PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA
- Title
- Retrieves the email address of the current user
- Archive Key 1
- -
- Archive Key 2
- -
- Created
- WRITER/B4A am: 2022-03-24 08:00:40
- Last Modified
- WRITER/B4A am: 2022-07-01 19:11:52 11 x
- Last Used
- -
SQL
- Statement (MS SQL)
- SELECT USR_EMail1 AS “Mail Address” FROM oh JOIN usr ON oh_idnr = USR_OH_Idnr WHERE OH_Name = ? AND OH_Client = ?
- Statement (Oracle)
- SELECT USR_EMail1 AS “Mail Address” FROM oh JOIN usr ON oh_idnr = USR_OH_Idnr WHERE OH_Name = ? AND OH_Client = ?
- Result Format
Bind Parameters
| Number | Parameter |
|---|---|
| 1 | &$USER#/&$DEPARTMENT# |
| 2 | &$CLIENT# |
Attributes
Data & Formatting
- Data Type
- TEXT
- Force Upper Case
Script Access
- If key not found
- INITIAL_VALUES