You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 30 Next »

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

Role required: admin.

You can create a column in two ways:

  • via table forms
  • by adding a record to the All Columns table

Columns can be added only to existing tables.

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

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

To create a column record in the All Columns table, complete the following steps:

  1. Navigate to System Definition → All Columns.
  2. Click New and fill in the form.
  3. Click Save or Save and Exit to apply the 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 added to them.

This field references to the Tables (sys_db_table) dictionary.

Column Type

Y

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

Title

YSpecify a column title displayed on the form. It should be meaningful and human-readable. You can use Latin or Cyrillic letters, [0..9] numbers and the underscore symbol ( _ ).

Column Name

Y

System column name. This field is populated automatically, depending on the title entered. Latin letters, [0..9] numbers, and the underscore symbol ( _ ) are allowed.

Column name prefixes are added, depending on the 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. For example:

    TitleColumn name
    New columnc_new_column
  2. If you create a column within a table related to non-vendor applications, then the prefix is not added.

Comments

NAdd some comments describing the column.

Active

N

Select the checkbox to activate or deactivate the column.

If not selected, the column will be not visible in the Form Layout or List Layout configuration.

Read Only

N

Select the checkbox to make the field read-only.

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

Mandatory

NSelect the checkbox to make the field mandatory.

Full Text Search

N

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

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

Display by Ref

N

Enable the attribute Display by Ref, so the column value is displayed in the reference fields.

By default, this attribute is equal to true for the sys_id column. This column contains unique IDs.

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

Unique

NSelect the checkbox to prevent from adding a new record with a certain value, if a record with the same value already exists.

Type Specification tab

In SimpleOne, several column types have an extended attribute set. In addition to the standard field set, 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 on the Type Specification tab.

Most column types can have a limited number of characters defined by the Max Length field.

AttributeMandatoryDescription

Max Length

N

Specify the maximum value length for the column. The value length cannot exceed the 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.

See the Choice columns article to learn more about this column type.

FieldMandatoryDescription

Choice Table

NReference to a table.

Choice Field

YReference to a particular column of the table specified in the Choice Table field.

Choice Type

Y

Define whether the option "None" is applicable for the field. Available options:

  • Dropdown with --None--
  • Dropdown without --None-- (specify a default value)

If the Dropdown without --None-- is selected, the Default Value tab becomes mandatory.

Extra Attributes

N

Type the text below to apply the radio buttons style to the choice field:

choice_decorator=radio

Conditions column type

See the Conditions columns to learn more about this column type.

FieldMandatoryDescription
Dependent on ColumnYSpecify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary to build conditions.
Extra AttributesN

Specify the extended operators. For example:

extended_operators=VALCHANGES;CHANGESFROM;CHANGESTO;IS_CALCULATED

These operators become available for use on the column view.

Reference column type

See the Reference Fields to learn more about this column types.

FieldMandatoryDescription
ReferenceYSpecify a dictionary with the values you need.
On DeleteN

Define actions to be taken in case the referenced record is deleted. The field appears on the Type Specification tab. Available options:

  • No Action – no actions will be taken.

  • Set NULL – the reference to this record will be deleted from the field (the value will be equal to 'null').
    When deleting a record A, an update error of a record B can occur if the record has a column that references the record A and the Action on delete for this column is Set NULL.

    Error
    Unable to update the {link} record because it references to the deleted one
  • Cascade – a record containing a reference to the deleted record will be deleted as well.
  • Restrict – deletion of the referenced record is forbidden.
  • Set Default – the reference to the column will be changed to the default value defined on the Default Value tab.

Make sure that you set the default value on the Default Value tab if the Set Default option is selected. In case the default value is not set, and the referenced record is deleted, the reference to this record will be deleted from the field (the value will be equal to 'null').

Image column type

FieldMandatoryDescription
Extra AttributesN

Specify the maximum image width and height. For example:

    • width=1600
    • height=800

Field Name and Template column types

FieldMandatoryDescription
Dependent on ColumnY

A reference to the Tables dictionary. Specify a table that will share the fields with the newly created column.

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 a new record is created. 

Use Dynamic Default

NSelect the 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 results are automatically calculated and entered into this field. This value will be the default value for the column specified.

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

Reference Qualifier tab

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 the checkbox to fix filters in the breadcrumbs of the dictionary when using this field. This functionality prevents from using the condition builder functionality.

  • No labels

© 2019-2024, SimpleOne

https://simpleone.ru