on Aug 23, 2016I 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.
Is the ${OptionalComments} variable not working?
No, I tried with this variable as well. It returns blank value.
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
Thanks Venkat.
Can we have that optional comment as a mandate one? Its a critical request from customer.
Please raise that request through the standard support channel.
All I would like to know, is it possible first of all, just by tweaking the existing configurations or we would need to develop custom form right from scratch.
I created one but unable to override the comment section which behaves concurrently with the performed action.
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