Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Form element tables
sys_ui_form
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
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. |
sys_ui_form_element
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
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_Form split _ element _ type | Enum form_split_element_type | (Contains from: begin_split, end_split, split). This column stores information about if the record is the form break-up element, and if yes, what kind of element is it . |
| 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. |
:
| ||
| Columncolumn_id | Reference | Reference to the sys_db_column column. The ID of the column that is the form section element. |
| position | Integer | The element position inside the section. |
| Form section | Reference | Reference to the sys_ui_form_section table. The ID of the section that is a parent for the element. |
sys_ui_form_section
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
| 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 | ||
| position | String | Tabs order on the form view. The first section is general and will not be a tab. |
| form_id | Reference | Reference to the sys_ui_form table. A form view that is a parent for the section. |
| titlePosition | String | The title of the form. |
sys_ui_formatter
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
| 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 Formatter
System name: sys_ui_formatter
Description: The widget configuration table. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| name | String | A widget name. |
| active | Boolean | IF TRUE, then this widget is active. |
| formatter | Choice | Available options: Activities. |
| type | Choice | Available options: Formatter. |
| table_id | Reference | Reference to the sys_db_table table, The ID of the table that will display the widget in its configuration of form section elements. |
List element tables
sys_ui_list
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
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 |
|---|---|---|
| title | String | The view title. |
| user_id | Reference | Reference to the user, owner of the form view. If user = null, then the view is shared. |
| table_id | Reference | Reference to the sys_db_table table, The ID of the table that is a parent for the view. |
sys_ui_list_column
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
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 |
|---|---|---|
| displayable_path | JSON | The dotWalking path to the column. |
| column_id | 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. |
| list_id | Reference | Reference to the sys_ui_list table. The ID of the list view that is a parent for the column. |
sys_ui_related_list
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
UI Related List
System name: sys_ui_related_list
.
Description: This table contains configurations of the related lists. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| table_id | Reference | Reference to the sys_db_table table. The ID of the table that is a parent for the related list. |
| user_id | Reference | Reference to the user, owner of the related list. If user = null then the list is shared. |
| title | String | The related list title. |
UI Related List Element
System name: sys_ui_related_list_element
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
Description: This table contains configurations of the elements of the related lists. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| related_column_id | Reference | Reference to the sys_db_column column, The ID of the related column. |
| related_list_id | Reference | Reference to the sys_ui_related_list table, The ID of the related list that is a parent for the element. |
| order | Integer | The elements order. |
| title | String | The related list element title. |
sys_url_action
Name
Is_extendable
Title
Read Access
Create Access
Update Access
Delete Access
Url Action
System name: sys_url_action
Description: The URL actions table. The actions are the links; after following them, some activities in the system will perform. It consists of the following fields:
Field | Type | Description |
|---|---|---|
| key | String | Generated hash. It will be inserted into URL and used as a keyword for a record search in a database when followed the URL. |
| assigned_to | Reference | Reference to the user table, the user. |
| executor_id | Reference | Reference to the user table, the user who has followed the link and run the action. |
| script | Script | Server-side script, it will be executed after following the link. |
| active | Boolean | IF TRUE, then this URL action is active. |
| expire_on | Datetime | After this datetime following the link will not run the script. |
| Table of Contents | ||
|---|---|---|
|