Versions Compared

Old Version 2

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version Current

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 Navigate to the System Logs → HistoryLogs → History to access system 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 Builderthe condition builder to configure the filters that will fit best suit your needs most.

History form fields

Field
Mandatory
Description
Table Name
YThe
Related table name.
Field Name
YThe changed
Changed field.
Record
Y
The record ID.
Old Value
N
Old record value.
New Value
N
New record value.
Type
Y

Change type:

  • Insert
  • Update
  • Delete
.
Username
Y
Username of the change originator.


Info

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

Activity Feed History 

The Activity Feed widget displays history of field changes. It displays information about those fields, the value of which have been changed.

  • Previous values are in gray color. The new values are black.
  • Field changes are displayed according to the history display settings.

By selecting the tabs under the input field, you can filter out the displayed information.


Section


Column
width20%

Image Added


Column
width70%

To display changes of the specific fields in the History section instead of all fields changes, complete the following steps:

  1. ClickImage Addedon the right to open the kebab menu.
  2. Click the Select fields item.
  3. Clear the checkboxes of fields whose changes should not be shown in the activity feed.
  4. Click Apply.



Info

If the history contains the fields that have been changed but are not selected in the Select fields handler, they will be replaced by the No fields selected text.


Record Deletion Log

This storage keeps 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.

To access this storage, navigate Navigate to System Logs → Record Deletion LogLog to read the storage records.

Info

Deletion logs are only available to tables with the selected Record Deletion Logging checkbox. See the Table AttributesCreate Tables 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 Builderthe condition builder to configure the filters that will fit best suit your needs most.

Field
Mandatory
Description
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.
JSON

This field stores the attributes of the deleted record

JSONNThis 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


Parent Record

The 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.

RecordThe ID 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 Buildercondition builder:
    • choose select one or several records by selecting checking the checkbox at 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 just before the deletion.


Note

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


Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse