Versions Compared

Old Version 3

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version 4

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

History


History storage displays the record field changes in all tables in the human-readable format.

Note

You cannot create, edit, or delete records in the History (sys_history) table. Only users with the admin role can read them.

Navigate to the System Logs → History to access system history.

If you need to find specific records or to sort them in a particular order, use the condition builder to configure the filters that best suit your needs.

History form fields

FieldDescription
Table NameRelated table name 
Field NameChanged field.
RecordThe record ID.
Old ValueOld record value.
New ValueNew record value.
Type

Change type:

  • Insert
  • Update
  • Delete
UsernameUsername of the change originator.


Info

Use the audit.tables.ignoredList property to specify tables whose changes will not be saved in history. 

Activity Feed History 


Record Deletion Log


This log stores the information about deleted objects. You can also restore them with this log.

Note

You cannot create and edit records in the Record Deletion Log (sys_record_deletion_log) table. Only users with the admin role can read and delete them.

Navigate to System Logs → Record Deletion Log to read the storage records.

Info

Deletion logs are only available to tables with the selected Record Deletion Logging checkbox. See the Create Tables article to learn more.

If you need to find specific records or to sort them in a particular order, use the condition builder to configure the filters that best suit your needs.

FieldDescription
JSON

This field stores the attributes of the deleted record in JSON format as an associative massive.

Code Block
languagejs
themeEclipse
{"sys_id": 162212096614481484, "title": "Smith", "sys_created_at": "2021-05-27 13:09:26", "sys_created_by": 155931135900000001, "sys_updated_at": "2021-05-27 13:09:26", "sys_updated_by": 155931135900000001}


Parent Record ID

ID of the deleted record that caused the current record to be deleted: if record A causes record B to be deleted, this causes deletion of record C, then record C will display the ID of record A ID (as the original cause). 

This field is populated in case when the On Delete attribute of the reference column is Cascade. See the Reference Fields article to learn more.

Record IDID of the deleted record.
Table NameTable name to which the deleted record belongs.
UsernameUser who initiated the record deletion.

Restore a record

To restore a record, perform the following steps:

  1. Navigate to System Logs → Record Deletion Log.
  2. Find the record you need using the list search or the condition builder:
    • select one or several records by checking the box on the left
    • open the record you need
  3. Click Restore.
Info

The restored record will have the attributes described in the JSON field. The system restores the record version as it was before the deletion.


Note

Records are restored independently of each other. For example, if deleting record A causes records B and C to be deleted, and then record A is restored, records B and C remain deleted. They shoulf be restored additionally.


Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse