Rules, JS, SQL

Starting SQL Subworkflow using Item List

0 5

Hello, I'm trying to start a subworkflow from an item list. My item list will have the candidate for Positions and it will not be filled at the same time, each time there's a candidate for an offer, the user creates a row. To start my subworkflow I'm using as conditions having the candidate name as not null and a flag set to true and i'm using this as an execution condition with the following SQL: if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCO (...)