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: Andreas Büsching am: 2020-09-15 11:31:45
Last Modified: WRITER/B4A am: 2022-06-13 18:34:20 22 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