Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
The SimpleOne system stores all the list and form views created along with the specified elements of these layouts.
| Tip |
|---|
Role required: admin. |
Deleting view items
Use these system tables if you want to delete forms, lists, sections, and other elements of the records view created.
| Note |
|---|
It is not recomended to delete the Default views and sections of the list and form layouts. |
List elements
When SimpleOne administrators create or change list layout views, the system stores all these changes in the tables below.
UI List
System name: sys_ui_list.
Description: This table contains configurations of list views of the tables. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| User | Reference | Reference to the user, owner of the form view. If user = null, then the view is shared. |
| Title | String | The view title. |
| Table | Reference | Reference to the sys_db_table table, The ID of the table that is a parent for the view. |
UI List Column
System name: sys_ui_list_column.
Description: This table contains configurations of the columns of list views of the tables. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| List | Reference | Reference to the sys_ui_list table. The ID of the list view that is a parent for the column. |
| Column | Reference | Reference to the sys_db_column column. The ID of the column is shown in the list view. |
| Order | Integer | The order of the columns. |
Form elements
When SimpleOne administrators create or change form layout views, the system stores all these changes in the tables below.
UI Form
System name: sys_ui_form.
Description: This table contains form view configurations. It consists of the following fields.
Field | Type | Description |
|---|---|---|
| Title | String | The view title. |
| User | Reference | Reference to the user, owner of the form. If user = null, then the view is shared. |
| Table | Reference | Reference to the sys_db_table table, the ID of the table that is a parent for the view. |
UI Form Element
System name: sys_ui_form_element
Description: A table for configurations of the section elements. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| Form split element type | Enum form_split_element_type | This column stores information about if the record is the form break-up element, and if yes, what kind of element is it:
|
| Column | Reference | Reference to the sys_db_column column. The ID of the column that is the form section element. |
| Form section | Reference | Reference to the sys_ui_form_section table. The ID of the section that is a parent for the element. |
| Position | Integer | The element position inside the section. |
| Formatter | String | This column stores formatter name and shares info about the element: is it a widget and if yes, what kind of widget it is. |
UI Form Section
System name: sys_ui_form_section.
Description: The table for the configurations of the record view form sections. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| Form | Reference | Reference to the sys_ui_form table. A form view that is a parent for the section. |
| Position | String | Tabs order on the form view. The first section is general and will not be a tab. |
| Title | String | The title of the form. |
UI Related List
System name: sys_ui_related_list.
Description: This table contains configurations of the related lists. See Related Lists to learn more. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| Title | String | The related list title. |
| Table | Reference | Reference to the sys_db_table table. The ID of the table that is a parent for the related list. |
| User | Reference | Reference to the user, owner of the related list. If user = null then the list is shared. |
UI Related List Element
System name: sys_ui_related_list_element.
Description: This table contains configurations of the elements of the related lists. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| Title | String | The related list element title. |
| Related list | Reference | Reference to the sys_ui_related_list table, The ID of the related list that is a parent for the element. |
| Related table | Reference | Reference to the sys_db_table table. The ID of the table that is a parent for the element. |
| Related column | Reference | Reference to the sys_db_column column, The ID of the related column. |
| Related list script | Reference | Reference to the sys_related_list_script script, The ID of the related script. See Relationships to learn more. |
| Order | Integer | The elements order. |
| Table of Contents | ||
|---|---|---|
|