Page History

In SimpleOne, all data stores is stored in two forms: tables and records. Tables consist of columns. A 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

Attributes

form 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.

A

The title

is preferred to

should be

sensible

meaningful and human-readable, like Incident

, or

or Known Error. You can use Latin or Cyrillic letters, [0..9] numbers, and the underscore symbol ( _ ).

Unlike the Name field, the values from the

The Title field can be translated to other languages.

When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix.

Name
Anchor
table_name
table_name

Name

Y

The

This field is populated automatically with a system table name. The table name should be unique and

inform about the data stored. Allowed symbols are

meaningful. You can use Latin letters, [0..9] numbers, and the underscore symbol ( _ )

; a

. The name should start with a letter. System table names are used in

scripting

scripts.

When filling in the Title field, the Name field is populated automatically with a corresponding value and prefix.

Info
Typically, developers create tables while working on applications and within these applications. In this case, a prefix is automatically added

automatically

to the system table name. You can specify

the

a default prefix to add

in

to the application settings

; this point is highlighted in the Applications article

. See the Applications article to learn more.

Note

title	Table Naming Policy

The default table naming policy is

configured

as follows

.

:

For custom tables created within the Simple application, the

"

c

_" prefix

prefix is added.

Example

- For example: if you create a table and specify the title "Table,"

,

- then the name c_table is generated automatically.
For custom tables created within another application, an application prefix and a client instance prefix are added.

Example

- For example: consider that you are creating a table within the ITSM application (generally having the itsm prefix) on your instance.

Vendor

- The vendor has provided the instance client prefix for you. The title of the newly created table is "Table

". In this case, it will be named as

- ." As a result, the itsm_instance_table name will be generated automatically.

In table names, elements are

compounded

connected with the underscore symbol.

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

its is_extendable attribute is equal to 'true'

the Is extendable checkbox is selected.

Is

Extendable

extendable

N

Select the checkbox

so that

to make the table

could

extendable. It can be a parent for

another table

other tables. For more information

about this

,

please

refer to the Table Extension article.

Add

Menu Item

menu item

N

Select the checkbox to create a new menu category in the Navigation menu

if needed. If the checkbox is selected, the Menu Item tab will appear in the Related Lists areaPrefix

, or add the table as a new menu item for an existing menu category.
Controls Tab

AttributeMandatoryDescription

Record number

N

Define a prefix that will be added at the beginning of every record

ID

number in this table.

Is VCS

Enabled

enabled

N

This attribute is responsible for

Select the checkbox to enable the table versioning

turning on and off. When this checkbox is selected, changes

. Changes in the affected table are stored as records in the VCS records (sys_vcs_record) table.

Note

Please keep in mind that you will be unable to change this attribute value after table creation, so it is necessary to get through this phase carefully.

This field is read-only after the record is created.

Is audit

N

Select the checkbox to log the changes in the affected table

Is Audit

NThis attribute is responsible for the records changes logging

to the History (sys_history) table.

When the checkbox is selected, the changes in the affected table are logged in the mentioned table. Read more about this in the

See the Record Audit article to learn more.

Record deletion logging

System History section.Record Deletion Logging

N

Select

this checkbox to enable logging record deletion. Records

the checkbox so that records deleted from this table

will be

are logged to the Record Deletion Log (sys_record_deletion_log) and can be restored.

Menu Item tab

Indicate presence

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 tab

Anchormenu item tab sectionmenu item tab section

The Menu Item tab appears when the Add

Menu Item

menu item attribute is selected.

AttributeMandatoryDescriptionMenu Category

Menu category	Y	Specify a menu category to which the menu item should be related.
Menu

Item

item

N

Specify a name of the new menu item.

New

Add menu category

N

Select the checkbox if you want to create a

new

menu category

item

.

Then the following fields will appear:

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

Field

Mandatory

Description

New CategoryYDisplayed category title.OrderYCategory order in the interface (categories are arranged in ascending order).Menu ItemNThe

name of the new menu item.

See the Navigation article to learn more about menu items and categories.

UI Actions

This field appears when the Add menu category checkbox is selected.

User interface actions

After a table is created, the following user interface After creation, the following UI actions appear on the table form:

Configure from 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 a list of a table.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 a the table list.
Show schema – opens a dependency map and shows all the tables related to a the table which form you opened. You can click any table name on the dependency map to open the table form of the table. The picture image below is an example of a dependency map.

Table of Contents

absoluteUrl	true
class	fixedPosition
printable	false

Page tree

Versions Compared

Old Version 5

New Version Current

Key

Main area

Title

Name
Anchor
table_name
table_name

Parent

Is

extendable

Add

menu item

Controls Tab

Is Audit

Menu Item tab

The Menu Item tab appears when the Add

UI Actions

User interface actions

Page tree

Page History

Versions Compared

Old Version 5

New Version Current

Key

Main area

Title

Name Anchortable_nametable_name

Parent

Is

extendable

Add

menu item

Controls Tab

Is Audit

Menu Item tab

The Menu Item tab appears when the Add

UI Actions

User interface actions

Name
Anchor
table_name
table_name