TIM Wiki / NEW TIM 6 Documentation

Je Prozess müssen der Name der Prozessdefinition

WHERE name_ = "SAP Anforderung"

und der Name der Node

WHERE name_ = "waitState2"

angepasst werden.

Hier der Query:

SELECT processInstance_ID_ FROM loom_nodeinstance l WHERE processInstance_ID_ IN (SELECT ID_ FROM loom_processinstance l WHERE processdefinition_ IN (SELECT ID_ FROM loom_processdefinition l WHERE name_ = "SAP Anforderung") AND archiv_ = FALSE AND deleted_ = FALSE) AND name_ = "waitState2" AND realStart IS NOT NULL AND realEnd IS NULL;