AnsweredAssumed Answered

How to retrieve Manual Fulfillment Activity No in WF?

Question asked by Ece YILDIRIM on Aug 16, 2016
Latest reply on Aug 22, 2016 by Venkata Ramana Reddy Kanaparthy
  • Comment • 2

We need to display below Activity No (in red request) inside email body sent to task owner.

 

 

 

 

What is the correct workflow variable to retrieve this value? 

 

When I put ${Job.JobID} as runtime variable I get below result.

Venkata Ramana Reddy Kanaparthy
Venkata Ramana Reddy Kanaparthy Employee Aug 22, 2016 6:19 AM
Correct Answer

Tried adding a SQL select node as shown below in the fulfillment workflow and it worked for me.

 

 

 

SQL Query:  select acti_id as manual_activity_id from wp_proci_node where proci_id || ':' || proci_db = ${Job.JobID} and NAME = 'Manual Fulfillment'

 

The Result:

 

 

See the reply in context
No one else had this question

Outcomes