In several cases I had an error in workflow which forced me to change node state manually.
This successfully completes the node but I did not find where the completion comment is stored. If I reopen the workflow I did not find even any indication that the node was completed manually.
It can be needed from auditing perspective.
I can't find it either by looking in the database for all columns having the value of the comment I put, nor using debug parameter for the WF architect to display more info. My assumption is:
1. either the comment is in a blob/clob column where that would be a reason why the search script didn't find any table/column that contains the comment value
2. We aren't storing the comment in the db
Tagging Mostafa Helmy if he has anything to add here.
Thanks for checking!
i think the best option then is to raise an enhancement then.
RSA Ideas for RSA Identity Governance & Lifecycle
unless Sean Miller knows where this data is
Take a look at WP_WORK_ITEM_HIST and WP_PROCI_NODE_HIST. I am not sure if this data gets truncated or not though when the workflow completes. What are you trying to do with that data?
I can't find it either by looking in the database for all columns having the value of the comment I put, nor using debug parameter for the WF architect to display more info. My assumption is:
1. either the comment is in a blob/clob column where that would be a reason why the search script didn't find any table/column that contains the comment value
2. We aren't storing the comment in the db
Tagging Mostafa Helmy if he has anything to add here.