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.

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 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, i.e., attributes and their values.

Edit a record

To edit a record via the agent interface, you can either change values in the fields of the record form, or 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.

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 (including records in parent/child tables). 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.