AnsweredAssumed Answered

is it possible to fetch activity Instance Id in SQL Node in workflow.

Question asked by Hemant Mandle on Sep 27, 2017
Latest reply on Sep 28, 2017 by Hemant Mandle

Hello All,

 

I am trying to customize a workflow with SQL node, and would like to query "AVUSER.PV_CHANGE_REQUEST_ACTIVITY" table based on Activity Instance ID in where clause, but i dont find any value when i do right click on SQL Node. What i find is values related with Change Request , not with individual items under it.

 

Purpose of doing this customization is, i am trying to find the action taken by Approver (Reject / Accept) using SQL Node. Also, my workflow is set to "Process:Create an individual job for each change".

 

Thanks

Hemant.

Outcomes