Versions Compared

Old Version 9

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version 10

changes.mady.by.user Dina Baksheeva

Saved on

Key

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

There are two types of objects in our system: tables and columns. Tables consist of columns. Both of these objects can be created via the agent interface.

Tip

Role required: admin.

A column can be created in two You can create a column in two ways:

  • Via the via table updating formforms
  • by adding a Adding the record to the All Columns table.
Info

Columns can be added only to existing tables.

To create a column via a table form, complete the following stepsOption 1:

  1. Navigate to System Definition → All Tables.
  2. Choose a the table you need to add a column to.
  3. Click New in the Column tab in Scroll down to the Related Lists area and select the Column tab.
  4. Fill Click New and fill in the form.
  5. Click Save or Save and Exit to apply changes.

Option 2To create a column record in the All Columns table, complete the steps below:

  1. Navigate to System Definition → All Columns.
  2. Click New and fill in the form.
  3. Click Save or Save and Exit to apply changes.

Column attributes

AttributeMandatoryDescription

Table

Y

Specify the table in which the column should be created. If this table has child tables, then this column will also be available within them.

This field references to the Tables (sys_db_table) dictionary.

Column Type

For more information about the column attributes, please refer to the Column Attributes article.

Y

Specify a column type. The column type specifies the type of the data stored, also, depending on the type selected, additional tabs or fields may appear on the form (see below). For more information, please refer to the Column Types article.

Title

YA column title displayed on the form. It is preferred to be sensible and human-readable. Latin, Cyrillic, [0..9] numbers and the underscore symbol ( _ ) are allowed.

Column Name

Y

A system column name. It is preferred to be human-readable and keep the kind of stored data. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed.


Note

This field is populated automatically depending on the title entered. Also, column name prefixes may be added depending on the column name creating circumstances listed below:

  1. If you create a column within any table related to vendor applications (Simple, ITSM or Personal Schedule), then this column automatically gets the "c_" prefix.
  2. If you create a column within a table related to non-vendor applications, then prefix is not added.

Example for case 1

Column titleNew column name
New columnc_new_column



Active

N

Select this checkbox to activate or deactivate the column.

If unselected, such field will be not available for choosing in Form Layout or List layout.

Read Only

N

Select this checkbox to make the field read-only.

Info

The Read Only attribute is not available for selecting when the Journal Input type is chosen in the Column Type field. 


Mandatory

NSelect this checkbox to make the field mandatory.

Full Text Search

N

Select this checkbox to make it possible to perform a Global Search against the current column.

Info

Please note that after activating this attribute, search indices (records in the Search Indices (sys_search_index) table) for existing records will not be created automatically. To create these indices, update the records.


Display by Ref

N

When a record references to another record and the table or column containing this record has the attribute Display by Ref equal to 'true', then the column value will be displayed.

By default, this attribute is set equal to 'true' for the sys_id column (this column contains unique IDs).

If a table contains a field that has Display by Ref equal to 'true', the value of this field will be displayed when referencing this table in the Reference field of the referencing table.

Unique

NWhen selected, there is no way to add a record with a value of this field, if a record with the same value already exists.

Type Specification Tab

In SimpleOne, several column types have an extended attribute set, unlike other types. In addition to the standard fieldset, these column types demonstrate a dynamic change of the sys_db_column object attribute set depending on its type. Some of these attributes can be defined in the Type Specification tab.


Tip
iconfalse
titleMost column types can have limited number of characters defined by the Max Length field.


AttributeMandatoryDescription

Max Length

N

Specify the maximum value length for this column. The value length cannot exceed allowed length for the specified data type.


The Choice, Conditions, Reference, List, Image, Template, and Field Name column types have a specific set of fields. See the description in the sections below:






Default Value Tab

The Default Value tab is available for all column types.

AttributeMandatoryDescription

Default Value

N

Specify a default value that will be populated automatically to the field when creating a new record. This field may be specified by a Javascript scenario as well.

Image Added

Use Dynamic Default

NSelect this checkbox if you want to generate the default value dynamically.

Dynamic Default

N

This field appears only when the Use Dynamic Default attribute is set to 'true'.

Select the script from the Dynamic Default Values (sys_default_value_dynamic) dictionary, so its execution result will be automatically calculated and entered into this field. This value will be the default value for the column specified.

Note
  1. The script must preliminary be created in the Dynamic Default Values (sys_default_value_dynamic) dictionary; otherwise, you will be not able to choose it.
  2. You can choose only active scripts (the Active attribute is equal to Yes).


Reference Qualifier Tab

Info

The Reference Qualifier tab appears for the following column types:

  • Field Name
  • List
  • Reference


FieldMandatoryDescription

Reference Qualifier Type

N

Select the type of reference qualifier. Available options:

  • Simple
  • Dynamic

Reference Qualifier Condition

N

Configure the filters using the Condition Builder.

This field appears when the Reference Qualifier Type value is Simple.

Dynamic Reference Qualifier

N

Select the dynamic reference qualifier from the list.

This field appears when the Reference Qualifier Type value is Dynamic.

Reference Qualifier Fixed

NSelect this checkbox to fix the breadcrumbs in the dictionary when using this field. This functionality will block using the Condition Builder functionality in this field
InfoColumns can be added only to existing tables
.