I would like to know the table or view which contains the information of fulfillment activity in AVDB.
My objective is to extract the comments from Manual Fulfillment Task Activity Form and to be displayed in Email Node.
I would like to know the table or view which contains the information of fulfillment activity in AVDB.
My objective is to extract the comments from Manual Fulfillment Task Activity Form and to be displayed in Email Node.
Ok. Try to use below query with a SQL Select node in the fulfillment workflow to get the latest comments on the activity. The SQL select node should be after the manual fulfillment node.
select OPTIONAL_COMMENTS from (SELECT OPTIONAL_COMMENTS FROM V_AV_WFWORKITEM_HISTORY
WHERE ACTI_ID=(select acti_id from wp_proci_node where proci_id || ':' || proci_db = ${Job.JobID} and NAME = 'Manual Fulfillment') AND OPTIONAL_COMMENTS IS NOT NULL
ORDER BY LU_DATE DESC) WHERE ROWNUM = 1
Ok. Try to use below query with a SQL Select node in the fulfillment workflow to get the latest comments on the activity. The SQL select node should be after the manual fulfillment node.
select OPTIONAL_COMMENTS from (SELECT OPTIONAL_COMMENTS FROM V_AV_WFWORKITEM_HISTORY
WHERE ACTI_ID=(select acti_id from wp_proci_node where proci_id || ':' || proci_db = ${Job.JobID} and NAME = 'Manual Fulfillment') AND OPTIONAL_COMMENTS IS NOT NULL
ORDER BY LU_DATE DESC) WHERE ROWNUM = 1