Implements the CONSTANTS workflow node. Reads all rows from a named
database table and injects them as key-value pairs into
run_context['result'], making them available to downstream nodes as
$key$ placeholders in CALC SQL statements and service attributes.
The first column of each row is used as the key (lowercased); the
second column is used as the value. All standard constants tables
follow this two-column convention.
| Node Type | Icon | BPMN | Status |
|---|---|---|---|
CONSTANTS |
🔑 |
Data Object | Implemented |
| Column | Purpose |
|---|---|
Type |
CONSTANTS |
Name |
Table name to query (e.g. data_constants, def_constants) |
Param1 |
Optional override for the table name (takes precedence) |
Param2 |
Optional WHERE clause appended to the SELECT |
param1 (if set) or name.SELECT * FROM <table> (plus WHERE <param2> if provided).run_context['result'] with lowercase keys.INSERT INTO def_workflows
(WorkflowName, Package, Rank, Type, Name, BranchDirect)
VALUES
('MY_WF', 'core', 5, 'CONSTANTS', 'data_constants', 'next_node_guid');
After execution, values such as BillingDate and lowbalance become
available as $billingdate$ and $lowbalance$ in downstream CALC SQL.
INSERT INTO def_workflows
(WorkflowName, Package, Rank, Type, Name, Param2, BranchDirect)
VALUES
('MY_WF', 'core', 5, 'CONSTANTS', 'def_constants', "Package = 'MYPACKAGE'", 'next_guid');
INSERT INTO def_workflows
(WorkflowName, Package, Rank, Type, Name, Param1, BranchDirect)
VALUES
('MY_WF', 'core', 5, 'CONSTANTS', 'LOAD_CONSTS', 'my_settings_table', 'next_guid');
| Table | Key Column | Value Column | Notes |
|---|---|---|---|
def_constants |
Constant |
Value |
Filtered by Package |
data_constants |
Variable |
Value |
Package-agnostic live data |
After a CONSTANTS node reads data_constants, a CALC node can use:
SELECT *
FROM my_table
WHERE balance < $lowbalance$
AND billing_date = '$billingdate$'
ObjWorkflowNode.py — Base node classObjWorkflow.py — Workflow orchestration engineObjWorkflowCalc.py — Downstream consumer of $key$ placeholdersObjEnum.WorkflowNodeType — Node type definitions (CONSTANTS)ObjConstants.WorkflowNodeIcons — Icon constants (🔑)Updated: 2026-03-02