BBC.SHARED.VARA@SEC_SQLI.GET-EMAIL-ADDRESS
Description
Details
| Property | Value |
|---|---|
| Type | VARA |
| Folder | PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA |
| Title | Retrieves the email address of the current user |
| Archive Key 1 | - |
| Archive Key 2 | - |
| Created | Andreas Büsching am: 2022-06-28 13:39:52 |
| Last Modified | Andreas Büsching am: 2025-07-04 17:07:26 2 x |
| Last Used | - |
SQL
- Statement (MS SQL)
- SELECT USR_EMail1 AS "Mail Address"FROM ohJOIN usr ON oh_idnr = USR_OH_IdnrWHERE OH_Name = ?AND OH_Client = ?
- Statement (Oracle)
- SELECT USR_EMail1 AS "Mail Address"FROM ohJOIN usr ON oh_idnr = USR_OH_IdnrWHERE 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