BPM Worklist: SQL query to skip approval if job requisition is pipeline
Summary:
I need to skip the job requisition approval in 2 scenarios:
- Job requisition is created as pipeline
- Job requisition is not having position id
However the skip rule i have written is not working. Can someone help in correcting the code.
Code:
oraext:query-database-with-bindvar(
CONCAT ('SELECT COUNT(*) AS L_COUNT
FROM IRC_REQUISITIONS_B req
WHERE (req.PIPELINE_REQUISITION_FLAG = ''Y''
OR (req.PIPELINE_REQUISITION_FLAG = ''N'' AND req.POSITION_ID IS NULL))
AND req.requisition_id = :bind_header_id
AND bind_header_id=', /task:task/task:payload/ns1:TransactionApprovalRequest/ns1:ObjectId
),true(), true(),
'jdbc/ApplicationDBDS',) = 0
Tagged:
0