BBC.SHARED.VARA@SEC_SQLI.LIST-CALE-KEYWORDS
Description
Details
| Property | Value |
|---|---|
| Type | VARA |
| Folder | PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING |
| Title | Retrieves list of keywords of one calendar object |
| Archive Key 1 | - |
| Archive Key 2 | - |
| Created | System UC4 am: 2025-08-14 18:13:58 |
| Last Modified | Writer best4Automic am: 2026-10-08 13:27:33 6 x |
| Last Used | - |
SQL
- Statement (MS SQL)
- SELECT OKB_Name FROM OH JOIN OKB ON OH_IdNr = OKB_OH_IdNr WHERE OH_OType = 'CALE' AND OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
- Statement (Oracle)
- SELECT OKB_Name FROM OH JOIN OKB ON OH_IdNr = OKB_OH_IdNr WHERE OH_OType = 'CALE' AND OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
Result Format :
Bind Parameters
| Number | Parameter |
|---|---|
| 1 | &$CLIENT# |
| 2 |
Attributes
Data & Formatting
- Data Type
- TEXT
- Force Upper Case
- ❌
Script Access
- If key not found
- INITIAL_VALUES