Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
In SimpleOne, all data stores is stored in two forms: tables and records. Tables consist of columns. A table row is called a record and have a unique identifier.
Tip |
---|
Role required: admin. |
To create a new table, perform complete the following steps:
- Navigate to System Definition → All Settings→ All Tables.
- Click New and fill in the fields.
- Click Save or Save and Exitexit to apply the changes.
Table
AttributesTable attributes allow users to configure tables and connect them to other tables.
Main areaform fields
Prefix
Attribute | Mandatory | Description | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Title | Y | Specify a table title. The title should be sensible meaningful and human-readable, like Incident, or or Known Error. You can use Latin or Cyrillic letters, [0..9] numbers, and the underscore symbol ( _ ). Unlike the Name field, the values from the The Title field can be translated to other languages. When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix. Name | |||||||||||||
Name Anchor |
| Y | The This field is populated automatically with a system table name. The table name should be unique and inform about the data stored. Allowed symbols are meaningful. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ ); a . The name should start with a letter. System table names are used in scriptingscripts. When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix.
| ||||||||||||
Parent | N | Specify a parent table for this table. All fields of the parent table except for the system fields will be inherited when creating the table. A table can be a parent for another table if its is_extendable attribute is equal to 'true'the Is extendable checkbox is selected. | |||||||||||||
IsExtendableextendable | N | Select the checkbox so that to make the table could extendable. It can be a parent for another other tables. For more information, refer to the Table Extension article. | |||||||||||||
Add | Menu Itemmenu item | N | Select the checkbox to create a new menu category in the Navigation menu | if needed, or add the table as a new menu item for an existing menu category. | If the checkbox is selected, the Menu Item tab will appear in the Related Lists area.|||||||||||
Controls Tab |
Record number |
N | Define a prefix that will be added at the beginning of every record number in this table. |
Is VCS |
enabled | N |
Select the checkbox to enable the table versioning |
. Changes in the affected table are stored as records in the VCS records (sys_vcs_record) table.
|
| |
Is |
audit | N |
Select the checkbox |
to log the changes in the affected table |
to the History (sys_history) table. |
See the Record Audit article to learn more. |
Record |
deletion logging | N | Select the checkbox so that records deleted from this table |
are logged to the Record Deletion Log (sys_record_deletion_log) and can be restored. |
Indicate presence | N | Select this checkbox to enable the presence indication. When this checkbox is selected, the record forms of the table have an indication when other users interact with the same record. The presence indication is enabled by default for the Task table and its child tables. |
Menu Item tab |
The Menu Item tab appears when the Add |
menu item attribute is selected. |
Menu |
category | Y | Specify a menu category to which the menu item should be related. |
Menu |
item | N | Specify a name of the new menu item. |
Add |
menu category | N | Select the checkbox if you want to create |
a menu category. |
See the Menu Categories and Items article to learn more. |
Menu category title |
Field
Mandatory
Description
Y | Specify a |
category title to display. This field appears when the Add menu category checkbox is selected. | ||
Order | Y | Determine the category order in the navigator |
. Categories are arranged in ascending order |
. This field appears when the Add menu category checkbox is selected. |
Menu |
item | N | Specify the name of the new menu item. |
See the Navigation article to learn more about menu items and categories.
UI Actions
This field appears when the Add menu category checkbox is selected. |
User interface actions
After a table is created, the following user interface After creation, the following UI actions appear on the table form:
- Configure from form layout – opens the page , where you can set up a form of table records.
- Configure list layout – – opens the page , where you can set up columns that will be displayed on a list of a table.the table list.
- Configure inline editing – opens a window where you can restrict editing of table fields in the list view.
- Create record – opens a form to create a table record.
- Open list – opens a the table list.
- Show schema – opens a dependency map and shows all the tables related to the table which form you opened. You can click on any table name on the dependency map to open the table form of the table. The picture image below is an example of a dependency map.
Table of Contents | ||||||
---|---|---|---|---|---|---|
|