meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
releases:2026-05-23 [2026/05/23 12:00] – Add BPMN interoperability section claudereleases:2026-05-23 [2026/05/23 12:10] (current) – Add Workflow Timer Node (K93) claude
Line 90: Line 90:
  
 Schema: ''txtWT_BPMN_Source'' (MEDIUMTEXT) added to ''WorkflowTemplate''; ''BPMNImportLog'' audit table created. Schema: ''txtWT_BPMN_Source'' (MEDIUMTEXT) added to ''WorkflowTemplate''; ''BPMNImportLog'' audit table created.
 +
 +===== Workflow Timer Node =====
 +
 +New **Timer** node type in the Workflow Designer (K93). A Timer node pauses a workflow instance for a configured number of minutes and then advances it automatically - no human action required.
 +
 +**Configuration:** set the duration in minutes (minimum 1) and optionally an escalation node to route to when the timer fires instead of following the normal outgoing edge.
 +
 +**Runtime behaviour:**
 +
 +  - Engine arrives at a Timer node ? inserts a ''WorkflowInstanceEvent'' row (status ''Pending'', trigger datetime = now + N minutes)
 +  - Instance waits
 +  - ''workflow_engine'' cron tick ? ''wfe_ProcessTimerEvents()'' marks due events as ''Fired''
 +  - Next engine tick ? instance detects ''Fired'' status and advances (via escalation path if set)
 +
 +No new cron job - timer firing is integrated into the existing ''workflow_engine'' job (runs every minute).
 +
 +**Use cases:** follow-up reminders after a step, automatic escalation if no action is taken within a time limit, cooling-off periods between steps.
 +
 +Schema: ''WorkflowInstanceEvent'' table with ''strWIE_Status'' (Pending / Fired), ''dteWIE_Trigger_DateTime'', and ''dteWIE_Fired_DateTime''.