How to Add DFF values to ApprovalHumanTask BPM Task Title
Hi Experts,
We need to customize the Title of the Sales Order Approval BPM workflow notification (ApprovalHumanTask) by adding Descriptive Flex Field (DFF) values.
When we add:
Approval Request for Sales Order {0} Source Order {1} Number Sales Type {2}
{0} = $Task/task:task/task:payload/ns0:approvalHeader/ns0:OrderNumber
{1} = $Task/task:task/task:payload/ns0:approvalHeader/ns0:HeaderId
{2} = $Task/task:task/task:payload/ns0:approvalHeader/ns0:HeaderId
This works and give the output with HEADER_ID. However, we need the DFF values to {1} and {2}
To get the DFF values (ATTRIBUTE_CHAR4, ATTRIBUTE_CHAR3);
{1} = orcl:query-database(concat('SELECT ATTRIBUTE_CHAR4 FROM DOO_HEADERS_EFF_B DHE WHERE DHE.HEADER_ID = ',