You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BPM Worklist: SQL query to skip approval if job requisition is pipeline

Summary:

I need to skip the job requisition approval in 2 scenarios:

  1. Job requisition is created as pipeline
  2. 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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!