Versions Compared

Key

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

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 may have no access to all or some of these operations for a record or some of its fieldsto 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
on
  • in any record form of the required table.
  • Click Create
Recordon
  • recordin the configuration form of the required table.
  • Click Image Modified 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.
Note

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.
Click 
    1. Click Delete
 in
    1.  in the top right corner.
Select 
  • 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_idThe 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.

Code Block
languagetext
themeConfluence
https://<instance_url>/record/article/158815469913225806

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

Table of Contents
classfixedCondition
printablefalse