Skip to main content
Version: 1.23.3

Records

In SimpeOne, a record is the basic entity for storing and representing information. In the agent interface, you can work with a record using either form or list view.

Both users and processes can interact with any record. These interactions are represented by the CRUD (create, read, update, delete) operations. Depending on the access control list (ACL) settings, you can restrict access to some users or user groups to execute the CRUD operations.

Create a record​

You can create a new record via the agent interface in several ways:

  • Click New on the list view of the required table.
  • Click New in any record form of the required table.
  • Click Create record in the configuration form of the required table.
  • Click next to a reference type field related to the required table.
  • Fill in the fields of an existing record with new values and create a copy of the record.
caution

The size of the created record should not exceed 2.5 MB.

To download a JSON file with the records that were cut in version 1.19.1, use the following link: https://{storage_domain}/public-attachment/0/0/archive_cut_record.json The information on the cut records will also be available in the Main Log (sys_log) table.

Read a record​

When reading a record, the user of the system sees the available content of the record, that is, attributes and their values.

Edit a record​

To edit a record in the agent interface on the record form, update the values in the fields you need and click Save. Users with the admin role can also use the inline editing on the list view.

Delete a record​

You can delete a record via the agent interface in one of the following ways:

  • In the list view of the table containing the record you need to delete:
    1. Select the required records using the checkboxes to the left of the list.
    2. Click Delete in the top right corner.
  • Select Delete in the burger menu of the form of the record you need to delete.
tip

You can restore the deleted records from the Record Deletion Log (sys_record_deletion_log), if the table that contained the deleted record has the Record deletion logging checkbox selected.

Unique record ID​

Each record in an instance is identified by a unique 18-character ID called sys_id. The record ID must be unique within the same table within the source table and its parent and child. The record ID value cannot be changed.

You can find the record ID in the URL address of the record. In the following example, the record ID is 158815469913225806.

https://<instance_url>/record/article/158815469913225806

You can also find the ID of the record in the ID column of the list view.