BBC.SHARED.VARA@SEC_SQLI.LIST-OBJECT-TEMPLATES

Summary

Object type

VARA

Object Folder

PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING

Title

Returns a list of object templates

Archive Key 1

-

Archive Key 2

-

Created

WRITER/B4A am: 2022-03-24 08:00:38

Last Modified

WRITER/B4A am: 2022-07-01 19:11:50 11 x

Last Used

-

SQL

Statement (MS SQL)

SELECT OVW_VValue AS “Name”, OVW_Value1 AS “Object” FROM OH RIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNr WHERE OH_Name = ‘UC_OBJECT_TEMPLATE’ AND OH_Client = ? AND OH_DeleteFlag = 0

Statement (Oracle)

SELECT OVW_VValue AS “Name”, OVW_Value1 AS “Object” FROM OH RIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNr WHERE OH_Name = ‘UC_OBJECT_TEMPLATE’ AND OH_Client = ? AND OH_DeleteFlag = 0

Result Format

Bind Parameters

Number	Parameter
1	&$CLIENT#

Attributes

Data & Formatting

Data Type

TEXT

Force Upper Case

Script Access

If key not found

INITIAL_VALUES