DELETE_METHOD
= optional in PARAM
Parameter (col A in PARAM) |
Mandatory/Optional |
Value in col C (example) |
Occurrence in PARAM sheet |
Comment |
|
---|---|---|---|---|---|
FORM |
REPORT |
||||
N/A |
0/1/2/3 |
1 |
Decide if audit trail should be created for all values that you update in a form. |
DELETE_METHOD is an optional FORM parameter that can be used if the designer wants to change the default instant delete method that Bizview uses. By default, Bizview instantly deletes values before values are updated to the database. In the new data engine you can also decide if the values deleted should be saved with another row_status, thereby creating an audit trail of each value updated to the database. Audit trail means that no values are deleted, but instead marked and moved to audit trail, which gives the user full overview of all actions/values that have been entered in a cell. The audit trail allows you to track changes in a cell back to the beginning and view how the values have changed over time.
Delete Method Values:
- 3: Audit Trail. The old data is marked to be moved to Audit Trail. A job must be executed to move the records (same procedure as Delete method: 2).
Access Audit Trail from Template Design by selecting Parameters > Data Update > Audit Trail:
If your template is also specified to create Audit trail records, upon opening a form you can right-click in a cell and select Audit Trail:
In the Audit trail dialog, you can view all updates and transactions done in that particular cell:
Delete Method Values in Old Data Engine
If you run Bizview and your template is not migrated to the new data engine, the following delete methods can be used:
- 0: Instant delete (Default). Old data is deleted instantly and the user must wait until the delete is completed.
- 1: Background delete. The records are deleted after new values have been updated, but the delete is executed in the background and the user can continue to work.
- 2: Logical delete. The old data is marked to be deleted. A job must be executed to delete the records.
- 3: Audit Trail. The old data is marked to be moved to Audit Trail. A job must be executed to move the records (same procedure as Delete method: 2).