Logged data search

Other administrative forms > Logged data search

The Logged data search form stores and displays all changes made to a record, from the moment the Enable log of changes checkbox is ticked during the creation (or edition) of a table. This form is useful to audit users who have, for instance, arbitrarily edited or deleted a record. See the limitation of the time that logged data is available.

Open this form, usually located in the Misc folder under Administration in the navigation menu (otherwise, add it with the Menu editor). Select the desired Table and use the filters as criteria to find the record you are looking for (you may filter by table, record, field, type of change and/or by user). You can optionally specify:

  • A period of time (From - To)

  • To Show deleted records. This checkbox is enabled and ticked by default only when a field is chosen.

  • To Sort fields in a particular way. Select an item in the Sort fields list: Object (i.e., Record name) and Timestamp. Click the up-arrow button at the right of the list (to sort in ascending order on this column) or the down-arrow (to sort in descending order). The selected item is copied to the Sort order list, and ASC or DESC are added at its right (to indicate ascending or descending order, respectively). You may select an item in the Sort order list and click the left-arrow button to remove it from this list.

  • The Number of records you want to see at a time.

After choosing the desired settings, click the Search button and verify that a list is displayed below, showing changes made to records. The message "Your search did not match any logged records" will be displayed if no data is found with the given criteria.

In the displayed list, each row represents a logged change. The original state of the changed record, such as the record name, group, previous value, previous update time, the original form and the user performing the change, are displayed is the leftmost set of columns (under the Before heading).

The Type column indicates the type of change: INSERT, UPDATE, or DELETE.

The remaining columns at the right of the Type column (under the After heading) show the state of the record after the change.