Skip to main content

BBC.SHARED.VARA@SEC_SQLI.GET-EMAIL-ADDRESS

Description​

Details​

PropertyValue
TypeVARA
FolderPACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA
TitleRetrieves the email address of the current user
Archive Key 1-
Archive Key 2-
CreatedAndreas Büsching am: 2022-06-28 13:39:52
Last ModifiedAndreas 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​

NumberParameter
1&$USER#/&$DEPARTMENT#
2&$CLIENT#

Attributes​

Data & Formatting​

Data Type
TEXT
Force Upper Case
❌

Script Access​

If key not found
INITIAL_VALUES