Record is a minimum independent unit of SimpleOne platform. It is basically a container of information compiled from table columns, in other words, – set of field values. In the list view, it is displayed as a row. In the form view, it is displayed as a form with populated fields.
For example, the User (user) table contains a record with the following fields:
Field
Value
Login
john.doe
First Name
John
Last Name
Doe
Password
[hidden information]
LDAP Server
Source
Email
john.doe@email.com
Timezone
Europe/Paris
Date Format
YYYY.MM.DD
Active
true
Locked Out
false
Language
English
Photo
file
Every record has its unique ID that is used by the system in scripts, properties, and others. As a rule, in agent interface records have human-readable titles/names.
Interface
Forms
In SimpleOne, a record form may be divided into three parts:
Main area – contains the title and fields of the record. Every record has this structural element. It can also include sections.
Related Links area – contains the link UI Action, a hyperlink text. It can execute a script or lead to a defined page.
Related Lists area – contains lists of records from tables connected with the current one.
Lists
In SimpleOne, a list view includes the following elements:
Gear icon – click on this icon to change the set and order of columns displayed.
Information icon – click on this icon to see the preview information about the record. See the Customizing portal and agent views article to learn more.
List of records – records included into the table displayed in rows. You can select records using the checkboxes at the right.
Cell – the column value of a certain record. You can change the value using the DOC0000035 - Records.
Columns – names of columns of the current table. You can change the set and order in the list layout and call the context menu.
Search boxes – click the magnifier icon at the left of column names to open the list search boxes. Here, enter the value which a column should contain to find certain records. You can as well use the Condition Builder to filter records.