How do I get the complete comments of a workflow?

Note: In a workflow, a performer can enter comments while he/she is performing the task. And those comments are carried to the next performer in this workflow. When using WebPublisher workflow report to review the workflow instances, and in workflow history, you are only able to get the truncated comments back from WP's interface. Especially for those already aborted workflow instances, there is no way that you can get the complete comments back from WP's GUI. In some cases, those comments are very important to our customers and they need to find a way to get those comments back.

Here are the steps to get those comments back:

1) Identify the workflow from the dm_workflow table, get the r_object_id of the workflow:
select r_object_id, object_name from dm_workflow where object_name = 'your work flow name'

2) Identify the notes that are carried by this workflow:
select r_note_id from dmi_package where r_workflow_id = ' the object id of the workflow'

3) Get the content id of each of those note ids returned:
select r_object_id from dmr_content where any parent_id = 'the note id'

4) Go to DA, Administration->Job Management->Administration, use the "GET_PATH" method to find out the path of the files which stores the comments.

Following the above steps, you will be able to find all the comments carried by a specific workflow instance. One other way to get this information is to enable the session DMCL trace and look into the log file.