Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
There are two types of objects in our system: tables and columnsIn SimpleOne, all data is stored in tables. Tables consist of columns. Both objects can be created via the agent interfaceA table row is called a record and have a unique identifier.
Tip |
---|
Role required: admin. |
To create a new table, please 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
Attributesform fields
Table attributes allow users to configure tables and connect them to other tables.
Main area
Attribute | Mandatory | Description |
---|---|---|
Title | Y |
Specify a table title. |
The title |
should be |
meaningful and human-readable |
, like Incident or Known Error. |
You can use Latin or Cyrillic letters, |
[0..9] numbers, and the underscore symbol ( _ ). |
The Title field can be translated to other languages. |
Name Anchor |
| Y | This field is populated automatically with a |
Name
system table name. The table name should be unique and |
meaningful. You can use Latin letters, |
[0..9] numbers, and the underscore symbol ( _ ) |
. The name should start with a letter. System table names are used in |
scripts. 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 |
the Is extendable checkbox is selected. |
Is |
extendable | N | Select |
the checkbox |
to make the table |
extendable. It can be a parent for |
other tables. For more information |
, |
refer to |
the Table Extension article. |
Add |
menu item | N | Select |
the checkbox to create a new menu category in the Navigation menu |
, or add the table as a new menu item for an existing menu category. | ||
Controls Tab |
Record number | N |
This is the reference to the record previously created in the Number (sys_number) table. It defines the parameters of the system number for the records in the related table.
You can read more about the settings of this field in the Autoincrement article.Is VCS Enabled
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. |
Note |
---|
Please keep in mind that you'll be unable to change this attribute value after table creating, so it is necessary to get through this phase carefully. |
Info |
---|
The list of tables can be modified by setting up the vcs_ignore_tables property. This property specifies system tables that are not included to VCS by default. |
| ||
Is audit | N | Select the checkbox to log the changes in the affected table |
Is Audit
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 |
Tip |
---|
You can also find a Show schema link in the Related Links area. The dependency map is a UI Action map showing all the tables related to a table which form you opened. Click any table name on the dependency map to open the form of that table.
|
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 tabThe 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 |
. |
Field | Mandatory | Description |
---|---|---|
New Category | Y | Displayed category title. |
Order | Y | Category order in the interface (categories are arranged in ascending order). |
Menu Item | N | The name of the new menu item. |
See the Menu Categories and Items article to learn more. | ||
Menu category title | 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. This field appears when the Add menu category checkbox is selected. |
User interface actions
After a table is created, the following user interface actions appear on the table form:
- Configure 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 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 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 any table name on the dependency map to open the table form. The image below is an example of a dependency map.
Image Added
Table of Contents | ||||||
---|---|---|---|---|---|---|
|