AnsweredAssumed Answered

Escalation WF activity_id

Question asked by Adem Keskin on May 29, 2017
Latest reply on May 30, 2017 by Boris Lekumovich

Hello,

 

We have associated an Escalation WF in an Approval WF which is supposed to be triggered in the case if the Approver does not take an action in the duration date.

 

We want to write an sql query for the Escalation WF which provide us the information if the assignee person still have the approval activity open.

 

I have already developed a query but not sure how to retrieve JobID of approval workflow instance which initiated the escalation WF directly in escalation WF.

 

Any one has an idea on how to achieve this?

Outcomes