Page Comparison

...

Using this Grid, an Admin can track time stamps, Users, and IP Addresses as they relate to any change in data on any record in the database. Any time a record is changed there is an entry detailing the change. This can help an Admin track who when and what was changed in the database. Additionally, if records are deleted accidentally, this Grid has an option to restore the records one at a time. 

Note: An Event to cleanup records from the Audit Process can be scheduled. This process will remove unnecessary records from both database tables. This process removes all but the oldest duplicate record based on each PRIMARY_KEY.

Restore

The 'Restore' Image Modified button allows a User to restore a deleted record on an individual case by case basis. This is useful for repairing the database in the event of a malicious attack or an accidental deletion event. This functionality is new as of version 2.1.4.

In order to Restore a record, several things must be true.

• The Action must be 'Delete'. Filtering the Action column for deleted records will make finding the right record easier.
• Parent tables must be Restored before Child tables can be Restored. What this means, for example, is that an Action must be Restored before the associated Charges, Labor, Contacts, etc. can be Restored on the Action.
• Once an item is Restored, it will remain on the grid for History Reporting purposes.

1. Locate the record(s) to be 'Restored'
2. Select the record by single clicking to highlight.
3. Click the 'Restore' Image Modified button.
4. The record will be removed from the Audit grid and a system message will display indicating that the record was restored.

Any Restored records will appear in the grid as a Yes value in the Restored column. Insert excerptHTML AppendixHTML Appendixnopaneltrue