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-02-28 14:47:14

Last Modified

WRITER/B4A am: 2024-01-09 09:57:41 18 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

Attributes

Data & Formatting

Data Type

TEXT

Force Upper Case

❌

Script Access

If key not found

INITIAL_VALUES