Page History

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:

List View
UI List Column
Form View
UI Form Element
Form Section
Related List
Related List Element.

Note
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

descr

Form element tables

sys_ui_form

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

sys_ui_formFALSEsys_ui_formTRUETRUETRUETRUE

Description: This table contains form view configurations. It consists of the following fields.:

Field	Mandatory	Type	Description

title

Title

Y

String

The view title.

user_id


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

form

list view. If

user = null, then

the user is specified, the list view is personal. Othewise, the view is

shared

common to all users.

table_id

Table

Y

Reference

Reference to the

Table (sys_db_table

) table

, the

. 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 List Column

System name: sys_ui_

form

list_

elementFALSEsys_ui_form_elementTRUETRUETRUETRUE

column.

Description: This table contains configurations of the columns in list views of the tablesDescription: A table for configurations of the section elements. 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
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.
column_id	Reference	Reference to the sys_db_column column. The ID of the column that is the form section elementshown in the list view.position
Order	Y	Integer	The element position inside the section.form_section_idorder 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:

the ui_formsection table. The section element.

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

sys_ui_form_section

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

view.
Title	Y	String	The view title.

Form Section Element

System name: sys

sys

_ui_form_section

FALSEsys_ui_form_sectionTRUETRUETRUETRUE

.

Description: The table for the configurations of the record view form sections. It consists of the following fields:

form_id

Field	Mandatory	Type	Description

positionStringTabs order on the form view. The first section is general and will not be a tab.

Form

Y

Reference

Reference to

the

the Form View (sys_ui_form) table. A form view that is a parent for the section.

Position

title

Y

String

The title of

Tabs order on the form

.

sys_ui_formatter

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

sys_ui_formatterFALSEsys_ui_formatterTRUETRUETRUETRUE

Description: The widget configuration table. It consists of the following fields:

Field

Type

Description

nameStringA widget name.activeBooleanIF TRUE, then this widget is active.formatterChoiceAvailable options: Activities.typeChoiceAvailable options: Formatter.table_idReferenceReference to the sys_db_table table, The ID of the table that will display the widget in its configuration of form section elements.

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

List element tables

sys_ui_list

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

sys_ui_listFALSEsys_ui_listTRUETRUETRUETRUE

Description: This table contains configurations of list views of the tables. It consists of the following fields:

Field	Mandatory	Type
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

sys_ui_list_columnFALSEsys_ui_columnTRUETRUETRUETRUE

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:

begin_split
end_split
split.

Column

Y

Reference

Reference to the Column (sys_db_column) column

Description: This table contains configurations of the columns of list views of the tables. It consists of the following fields:

order of the columns.list_id the list table list view column

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 that is shown in the list viewthe form section element.order
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.

sys_ui_related_list

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

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_listFALSE

sys_ui_related_list

TRUETRUETRUETRUE

.

Description: This table contains configurations of the related lists. See Related Lists to learn more. It consists of the following fields:

table_id

Field	Mandatory	Type	Description
Title	Y	String	The related list title.
Table	Y		Reference	Reference to the the Table (sys_db_table table) table. The ID of the table that is a parent for the related list.user_id
User	N	Reference	Reference to the user, owner of the related list. If If user = null then the list is shared.title
Form	String	The related list title.	N	Reference	Reference to the Table (sys_ui_

related_list_element

Name

Is_extendable

Title

Read Access

Create Access

Update Access

Delete Access

form)table. A form view that is a parent for the section.

Related List Element

System name: sys_ui_related_list

FALSEsys_ui_related_listTRUETRUETRUETRUE

_element.

Description: This table contains configurations of the elements of the related lists. It consists of the following fields:

related_list_id the , order

Field	Mandatory	Type	Description
Title	Y	String	The related list element title.
Related List	Y
related_column_id	Reference	Reference to the sys_db_column column, The ID of the related column.
	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	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

sys_url_actionFALSEsys_url_actionTRUETRUETRUETRUE

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

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

class	fixedPosition

Page tree

Versions Compared

Old Version 2

New Version Current

Key

Deleting view items

List elements

List View

Form element tables

sys_ui_form

sys_ui_form_element

UI List Column

Form elements

Form View

sys_ui_form_section

Form Section Element

sys_ui_formatter

UI Form Element

List element tables

sys_ui_list

sys_ui_list_column

sys_ui_related_list

Related List

Related List Element

sys_url_action