The SimpleOne system stores all the list and form views created, along with the specified elements of these layouts.
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:
- List View
- UI List Column
- Form View
- UI Form Element
- Form Section
- Related List
- Related List Element.
It is not recommended 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 listed below.
List View
System name: sys_ui_list.
Description: This table contains configurations of list views of the tables. It consists of the following fields:
Field | Mandatory | Type | Description |
|---|---|---|---|
| Title | Y | String | The view title. |
| Form | N | Reference | Reference to the Form View (sys_ui_form) table. A form view that is a parent for the section. Fill in the field if the list view is used for a related list. |
| User | N | Reference | Reference to the user, owner of the list view. If the user is specified, the list view is personal. Othewise, the view is common to all users. |
| Table | Y | Reference | Reference to the Table (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 in list views of the tables. It consists of the following fields:
Field | Mandatory | Type | Description |
|---|---|---|---|
| List | Y | Reference | Reference to the List View (sys_ui_list) table. The ID of the list view that is a parent for the column. |
| Column | Y | Reference | Reference to the Column (sys_db_column) column. The ID of the column is shown in the list view. |
| Order | Y | 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 listed below.
Form View
System name: sys_ui_form.
Description: This table contains form view configurations. It consists of the following fields:
Field | Mandatory | Type | Description |
|---|---|---|---|
| Table | Y | Reference | Reference to the Table (sys_db_table) table, the ID of the table that is a parent for the view. |
| Title | Y | String | The view title. |
Form Section Element
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 | Mandatory | Type | Description |
|---|---|---|---|
| Form | Y | Reference | Reference to the Form View (sys_ui_form) table. A form view that is a parent for the section. |
| Position | Y | String | Tabs order on the form view. The first section is general and will not be a tab. |
| Title | N | String | The title of the form. |
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 | Mandatory | Type | Description |
|---|---|---|---|
| Form Split Element Type | N | Enum form_split_element_type | This column stores information about the kind of an element: if it is a break-up element, it specifies the type:
|
| Column | Y | Reference | Reference to the Column (sys_db_column) column. The ID of the column that is the form section element. |
| Position | Y | Integer | The element position inside the section. |
| Form Section | Y | Reference | Reference to the Form Section Element (sys_ui_form_section) table. The ID of the section that is a parent for the element. |
| Formatter | N | String | This column stores the formatter name and shares info about the element: whether the element is a widget and what kind of widget it is. |
| Widget Instance | N | Reference | Reference to the widget instance. See the Add widgets to a form article to learn more. |
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 | Mandatory | Type | Description |
|---|---|---|---|
| Title | Y | String | The related list title. |
| Table | Y | Reference | Reference to the Table (sys_db_table) table. The ID of the table that is a parent for the related list. |
| User | N | Reference | Reference to the user, owner of the related list. If user = null then the list is shared. |
| Form | N | Reference | Reference to the Table (sys_ui_form) table. A form view that is a parent for the section. |
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 | Mandatory | Type | Description |
|---|---|---|---|
| Title | Y | String | The related list element title. |
| Related List | Y | Reference | Reference to the Related List (sys_ui_related_list) table. The ID of the related list that is a parent for the element. |
| Related Table | N | Reference | Reference to the Table (sys_db_table) table. The ID of the table that is a parent for the element. |
| Related Column | N | Reference | Reference to the Column (sys_db_column) column. The ID of the related column. |
| Related List Script | N | Reference | Reference to the Scripted Related List (sys_related_list_script) script. The ID of the related script. See Scripted Related Lists to learn more. |
| Order | Y | Integer | The elements order. |