B4A.DEMO.VARA@SEC_SQLI.BLOCKED-WORKFLOWS
Details
| Property | Value |
|---|---|
| Type | VARA |
| Folder | PACKAGES/BEST4AUTOMIC/B4A.DEMO/SOURCE/HANDLE-BLOCKED-WORKFLOWS |
| Title | Retrieve list of blocked workflows |
| Archive Key 1 | - |
| Archive Key 2 | - |
| Created | System UC4 am: 2025-08-14 18:13:58 |
| Last Modified | Writer best4Automic am: 2026-08-17 13:01:24 3 x |
| Last Used | - |
SQL
- Statement (Oracle)
- SELECT CONCAT(OH_Name, ' (', EH_AH_Idnr, ')'), EH_Status, OH_Name FROM EH LEFT JOIN OH ON EH_OH_IdNr = OH_IdNr WHERE OH_Name like 'B4A.DEMO%' AND EH_Client = ? AND EH_OType = 'JOBP' AND EH_Status = 1560
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