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.
You can try using the ${jobUserData_ChangeRequestItem.ItemId} variable to get the change item identifier and then use it in your query to get ACTIVITY_INSTANCE_ID value from PV_CHANGE_REQUEST_ACTIVITY.
Change item ID is stored in the ID column in PV_CHANGE_REQUEST_ACTIVITY