Versions Compared

Old Version 18

changes.mady.by.user Nikolay Nikitin

Saved on

compared with

New Version Current

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In SimpleOne, all data 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, perform complete the following steps:

  1. Navigate to System Definition → All Settings→ All Tables.
  2. Click New and fill in the fields.
  3. 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

Prefix Menu Item. If the checkbox is selected, the Menu Item tab will appear in the Related Lists area
AttributeMandatoryDescription

Title

Y

Specify a table title. The title should be meaningful and human-readable, like Incident 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

Name 
Anchor
table_name
table_name

Y

This field is populated automatically with a system table name. The table name should be unique and meaningful. You can use symbols are Latin letters, [0..9] numbers, and the underscore symbol ( _ ); the . The name should start with a letter. System table names are used in scriptingscripts.

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 to the application settings; this point is highlighted in . See the Applications article article to learn more.


Note
titleTable Naming Policy

The default table naming policy is as follows:

  1. For custom tables created within the Simple application, the "c_" prefix  prefix is added.
    • For example: if you create a table and specify the title "Table," then the name c_table is generated automatically.
  2. For custom tables created within another application, an application prefix and a client instance prefix are added.
    • For example: consider that you are creating a table within the ITSM application (generally having the itsm prefix) on your instance. The vendor has provided the instance client prefix for you. The title of the newly created table is "Table." As a result, the itsm_instance_table name will be generated automatically.

In table names, elements are connected with the underscore symbol.


Parent

NSpecify 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 truethe Is extendable checkbox is selected.

Is

Extendable

extendable

NSelect the checkbox to make the table extendable (to . It can be a parent for other tables. ) For more information, refer to the Table Extension article.

Add

menu item

NSelect the checkbox to create a new menu category in the Navigation menu, 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 number in this table.

Is VCS

Enabled

enabled

N
This attribute is responsible for enabling and disabling

Select the checkbox to enable the table versioning.

When the 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 the table

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


Is

Audit

audit

N
When

Select the checkbox

is selected,

to log the changes in the affected table

are logged

to the History (sys_history) table.

For more information, refer to the System History section

See the Record Audit article to learn more.

Record

Deletion Logging

deletion logging

NSelect the checkbox so that records deleted from this table are logged to the Record Deletion Log (sys_record_deletion_log) and can be restored.

Indicate presence

N

Select this checkbox to enable the presence indication. When this checkbox is selected, the record forms of the

records of the table have

table have an indication when other users interact with the same record

.By default, the profile picture, name and an optional line, containing the user's position, are displayed

.

To change the information displayed in the optional line, edit the simple.presence_indication.additional_info_column_name system property.

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.

AttributeMandatoryDescription

Menu

Category

category

YSpecify a menu category to which the menu item should be related.

Menu

Item

item

NSpecify a name of the new menu item.

Add

Menu Category

menu category

N

Select the checkbox if you want to create a

new

menu category.

When selected, the following fields appear:

Field

Mandatory

Description

Menu Category Title

See the Menu Categories and Items article to learn more.

Menu category titleY

Specify a category title to display.

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

OrderY

Determine the category order in the navigator

(categories

. Categories are arranged in ascending order

)

.

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

Menu
Item
itemN

Specify the name of the new menu item.

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

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

User interface actions

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


Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse