Iris_Muttenthaler_7233

SQL for searching variables in workflow preconditions or postconditions

Discussion created by Iris_Muttenthaler_7233 on Nov 30, 2016
If you want to find out in which workflows a variable is used in the precondition or postcondition tab you can use the following SQL scripts, in my example for the usage of the variable RESTART_COUNT:

Oracle:
Select OH_Name, OH_Client from OH where OH_Idnr IN (select JPOV_OH_Idnr from JPOV where 
SYS.DBMS_LOB.SUBSTR(JPOV_Value,4000,1) ='&$RESTART_COUNT#');

SQL Server:
Select OH_Name, OH_Client from OH where OH_Idnr IN (select JPOV_OH_Idnr from JPOV where 
JPOV_Value ='&$RESTART_COUNT#');

Outcomes