Versions Compared

Old Version 1

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version 2

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.

To access System History, navigate to the System Logs → History.

If you need to find specific records or to sort them in a particular order, use a filter tool at the top of the page. Use the Condition Builder to configure the filters that will fit your needs most.

History form fields

FieldMandatoryDescription
Table NameYThe table name.
Field NameYThe changed field.
RecordYThe record ID.
Old ValueNOld record value.
New ValueNNew record value.
TypeY

Change type:

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

Activity Feed History 


Record Deletion Log


This storage keeps information about deleted objects. You can also restore them. 

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.

To access this storage, navigate to System Logs → Record Deletion Log.

Info

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

If you need to find specific records or to sort them in a particular order, use a filter tool at the top of the page. Use the Condition Builder to configure the filters that will fit your needs most.

FieldMandatoryDescription
Table NameNTable name to which the deleted record belongs.
Record IDNID of the deleted record.
Parent Record IDN

ID of the deleted record that caused deletion of the current record: if the record A causes deletion of record B, and this causes deletion of record C, then for the C record this field will display record A ID (as the initial cause). 

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

UsernameNUser who initiated the record deletion.
JSONN

This field stores deleted record attributes 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}


Restoring 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:
    • choose one or several records by selecting the checkbox at 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 record version as it was just before the deletion.


Note

Records are restored one by one, independently from each other. For example, if deletion of record A causes deletion of records B and C, and then record A is restored, records B and C will remain deleted. They need to be restored additionally.


Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse