Versions Compared

Key

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

There are two types of objects in our system: tables and columnsIn SimpleOne, all data is stored in tables. Tables consist of columns. Both objects can be created via the agent interfaceA 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:

  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

AttributeMandatoryDescription

Title

Y
A

Specify a table title.

A

The title

is preferred to

should be

sensible

meaningful and human-readable

. Like Incident, or

, like Incident or Known Error.

The allowed symbols are

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

Name 
Anchor
table_name
table_name

Y

This field is populated automatically with a

corresponding value and prefix.

Name

YA

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
titleTable Naming Policy

The default table naming policy is

configured

as follows

.

:

  1. For custom tables created within the Simple application, the
"
  1. c
_" prefix
  1.  prefix is added.
    Example
      • For example: if you create a table and specify the title "
    table
      • Table,"
    ,
      • then the name
    "
      • c_table
    " is
      •  is generated automatically.
    1. 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

      conjuncted

      connected with the underscore symbol.


      Parent

      N
      A
      Specify a parent table for this table.
       All
      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

      NSelect
      this
      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 
      the Table Extension article.

      Add

      Menu Item

      menu item

      NSelect
      this
      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 areaNumber ID
      , or add the table as a new menu item for an existing menu category.

      Controls Tab

      AttributeMandatoryDescription

      Record number

      N

      This is the reference to the record previously created in the Number (sys_number) table. It defines the parameters of the system number for the records in the related table.

      You can read more about the settings of this field in the Autoincrement article.

      Is VCS Enabled

      N

      Define a prefix that will be added at the beginning of every record number in this table.

      Is VCS enabled

      N

      Select the checkbox to enable the table versioning. Changes

      This attribute is responsible for the table versioning turning on and off. When this checkbox is selected, the changes

      in the affected table are stored as records in the VCS

      record

      records (sys_vcs_record) table.

      Read more about this in the Configuration packs section.
      Note

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

      Info

      The list of tables can be modified by setting up the vcs_ignore_tables property. This property specifies system tables that are not included to VCS by default. 



      Note

      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 this 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

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

      Indicate presence

      Tip

      You can also find a Show schema link in the Related Links area. The dependency map is a UI Action map showing all the tables related to a table which form you opened. Click any table name on the dependency map to open the form of that table.

      Image Removed

      Menu Item tab 
      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

      The Menu Item tab appears when the Add menu item attribute is selected.

      Menu category

      Anchormenu item tab sectionmenu item tab section
      AttributeMandatoryDescritpionMenu Category

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

      Menu

      Item

      item

      N
      The
      Specify a name of the new menu item.
      New

      Add menu category

      N

      Select

      this

      the checkbox if you want to create a

       new

      menu category

      item

      .

       Then the following fields will appear:

      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.

      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 are arranged in ascending order.

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

      Menu itemN

      Specify the name of the new menu item.

      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 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.
        Image Added


      Table of Contents
      absoluteUrltrue
      classfixedPosition
      printablefalse