BBC.SHARED.VARA@SEC_SQLI.LIST-AGENTGROUPS

Summary

Object type

VARA

Object Folder

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

Title

Returns a list of all agent groups

Archive Key 1

-

Archive Key 2

-

Created

WRITER/B4A am: 2022-02-28 14:47:16

Last Modified

WRITER/B4A am: 2024-01-09 09:57:40 18 x

Last Used

-

SQL

Statement (MS SQL)

SELECT OH_Name AS “Agent Group”, OHG_HostAttrType AS “Platform” FROM OH JOIN OHG ON OH_Idnr = OHG_OH_Idnr WHERE OH_OType = ‘HOSTG’ AND OH_Client = ? AND OH_DeleteFlag = 0

Statement (Oracle)

SELECT OH_Name AS “Agent Group”, OHG_HostAttrType AS “Platform” FROM OH JOIN OHG ON OH_Idnr = OHG_OH_Idnr WHERE OH_OType = ‘HOSTG’ AND OH_Client = ? AND OH_DeleteFlag = 0

Result Format

Bind Parameters

Attributes

Data & Formatting

Data Type

TEXT

Force Upper Case

❌

Script Access

If key not found

INITIAL_VALUES