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?
Not sure how to retrieve the requested information.
Out of curiosity, why do you want to check if the approver has completed the approval in the escalation workflow?
If the escalation workflow has been triggered it's safe to assume that the approval is still pending to be approved.