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 in any record form of the required table.
  • Click Create Recordrecordin 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.
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.
    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_idThe record ID must be unique within the same table (including records in parent/child tables). The record ID value cannot be changed.

The You can find the record ID can be obtained from in the record URL address . For of the record. In the following example, an article record with the URL shown in the example below has an ID of '158815469913225806'the record ID is 158815469913225806.

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

It can be retrieved either from the browser address bar, or by copying the URL of the item at the navigation panel or on You can also find the ID of the record in the ID column of the list view.

Table of Contents
classfixedCondition
printablefalse