If you want to generate reports on Workflow, you may noticed two tables in UCM schema called DocumentHistory and WorkflowHistory. Both of them audits and saves all actions done.
But those tables have few fields, notice DocumentHistory table
But those tables have few fields, notice DocumentHistory table
What if we want to add new fields to to the history, why? because I want to track changes on some custom fields and report them, another example if I want to track updates done on metadata fields using "Update" action.
Good news UCM is great, we can add our custom fields to the table (simply by modifying table structure), like adding xComments
At the end we can overwrite UCM query that inserts to the table actions' history. So we will modify IdocHistory, as the following
<tr>
<td>IdocHistory</td>
<td>INSERT INTO DocumentHistory (dActionMillis, dActionDate, dID, dRevClassID, dUser, dDocName, dAction, dSecurityGroup, xComments)
values(?, ?, ?, ?, ?, ?, ?, ?, ?)</td>
<td>dActionMillis int
dActionDate date
dID int
dRevClassID int
dUser varchar
dDocName varchar
dAction varchar
dSecurityGroup varchar
xComments varchar</td>
</tr>
