Audit Trail
Using an Audit Trail in a form enables you to track all updates made in each specific input cell. By default, Bizview does an instant delete of values when a user updates values in a form; meaning that previous values are removed and the new input values are saved, making it impossible to track changes in input cells back in time. However, if the Audit Trail option is configured in the form, tracking these changes in input cells becomes possible.
This topic contains the following sections:
Activate an Audit Trail in a Form
The criteria for showing the Audit Trail menu is that the template is a FORM, the DELETE_METHOD = 3, and the cell is a measure column.
Go to the right panel in Template Design for a FORM and select Parameters. The Audit Trail parameter displays in the Data Update category. Set this parameter to TRUE if Audit Trail should be used in the form.
Show an Audit Trail in a Form
Open the form and right-click on the actual cell. At first, "Audit Trail (Not Generated)" displays. Select Audit Trail (Not Generated) and a historical database will be created (it may take a while). Once the database is created, the Audit Trail displays (if the user has not switched sheets while the creation was executed).
Audit Trail displays updated values in chronological order. All data attributes, including comment columns for the complete row, also display at the end of each row. Note that Template ID is also included, since the data may have been entered in another template. Cell comments are, however, not included in the Audit Trail.
Next time, right-click and select Audit Trail and it will immediately display a set of records of all changes made to the current cell, as the historical database is already created.
For more information, see the following topics: