BBC.SHARED.VARA@SEC_SQLI.LIST-AGENTGROUPS
Details
| Property | Value |
|---|---|
| Type | VARA |
| 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: 2020-09-09 09:53:18 |
| Last Modified | Timon Schnakenberg am: 2024-10-15 11:42:23 25 x |
| Last Used | - |
SQL
- Statement (MS SQL)
- SELECT OH_Name AS "Agent Group", OHG_HostAttrType AS "Platform", OHG_HostAttrType AS "Platform"FROM OHJOIN OHG ON OH_Idnr = OHG_OH_IdnrWHERE OH_OType = 'HOSTG'AND OH_Client = ?AND OH_DeleteFlag = 0
- Statement (Oracle)
- SELECT OH_Name AS "Agent Group", OHG_HostAttrType AS "Platform", OHG_HostAttrType AS "Platform"FROM OHJOIN OHG ON OH_Idnr = OHG_OH_IdnrWHERE OH_OType = 'HOSTG'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