Where the Approver Comments are stored
Hi,
We have a workflow which requires two approvers, where the comments of the approvers are stored ( in whcih table).
Please note that to capture the comments for one approver we use the following code:
SELECT text_value
FROM wf_item_attribute_values
WHERE item_type = i.item_type
AND item_key = i.item_key
AND NAME LIKE 'WF%NOTE';
but once the second approver comments will override this.
so how we can capture the first approver and second approver comments.
Thanks in advance.
Regards....Ashraf