Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0000843" into parent

Column attributes define the type of data to store in the column, relations, and connections between columns, and system behavior.

Tip

Set of attributes differs depending on the column type.

Column attributes description


AttributeMandatoryDescription

Table

Y

Specify the table

name that will be a parent for this column. This field is a reference to the Tables dictionary

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

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,

see

refer to the Column Types article.

Info

Normally, you cannot change the value of this field once the column is created. However, if you cannot avoid it, there is a workaround, described in the Change Column Settings article. Use it with caution.


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 the prefix is not added.

Example for case 1

Column titleNew column name
New columnc_new_column


The maximum length of the column name is 63 symbols.

Info

Normally, you cannot change the value of this field once the column is created. However, if you cannot avoid it, there is a workaround, described in the Change Column Settings article. Use it with caution.


Active

N

Select this checkbox , and customizing of this field displayed on the form and list will be possibleto activate or deactivate the column.

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

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

NSet this attribute equal to TRUE

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

Info

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'true',   then the column value will be displayed.

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

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

Unique

NWhen turned onselected, 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

a

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:

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

FieldMandatoryDescription

Choice Table

NReference to a table.

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 chosen, the Default value tab becomes mandatory.

Choice Field

YReference to a particular column of the table specified in the Choice Table field
Fill in this field for the columns that have a String or Text type
.

Extra Attributes

N

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

Code Block
languagejs
themeEclipse
choice_decorator=radio

Image Added


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

FieldMandatoryDescription
Dependent on ColumnYA reference to the Tables dictionary. Specify a table that will share the fields with the newly created column.
Extra AttributesN
By filling this field, you become able to use extended parameters on lists and forms. Some examples:

You can specify the extended operators

for the Condition type column. Like

like this:

code

titleExample

extended_operators=VALCHANGES;CHANGESFROM;CHANGESTO

So, these operators become available to use on the column view.

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

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

The field appears at the Type Specification tab.

It defines actions to be taken in case the referenced record is deleted. Available options:

  • No action – no actions will be taken.
  • Set NULL – the reference to this record will be deleted from the field (the value is to be NULL).
    Deleting records with the Set NULL option selected causes update errors for the records that reference this record in a mandatory reference field. The error occurs:

    Unable to update the {link} record because it references to the deleted one


  • Cascade – the record containing reference to it will be deleted as well.
  • Restrict – deleting of the referenced record is forbidden.
  • Set default value – the reference to it will be changed to the default value defined at the Default Value tab.
Note

Set the default value at the Default Value tab if the Set Default option is chosen. 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 is to be NULL).


Image column type:

FieldMandatoryDescription
Extra AttributesN

Specify

For the Image type columns, you can specify

maximum image width and height, like this:

    • width=1600
    • height=800

This field allows extending column properties compared to the regular.

Default Value Tab

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 creating a new record. This field may be specified by a Javascript scenario as well.

Image RemovedImage Added

Use Dynamic Default

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

Dynamic

default

Default

N

This field appears only when the Use dynamic defaultDynamic Default attribute is set to TRUE'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 . This value will be the default value for the column specified.

Note
  1. The script must be preliminary 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).

Client-side logic on columns

In SimpleOne, several column types have an extended attribute set, unlike other types.

Depending on the column type, 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.

These column types and their additional attributes are listed below.

Column typeAdditional AttributeDescriptionCondition, Template, Field NameThe Dependent on column field; it has the Reference type.This field appears at the Type Specification tab. It's a reference to the Tables dictionary. In there, you can specify a table that will share the fields with the newly created column.Reference, ListThe Reference field; it has the Reference type.This field appears at the Type Specification tab. This field is mandatory for fields of the reference type (Reference or List); for these fields, specify a dictionary with the values you need.The On Delete field.

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

  • No Action – if the referenced record is deleted, no actions will be taken.
  • Set NULL – if the referenced record is deleted, the reference to this record will be deleted from the field (the value is to be NULL).
  • Cascade – if the referenced record is deleted, the record containing reference to it will be deleted as well.
  • Restrict – deleting of the referenced record is forbidden.
  • Set Default – if the referenced record is deleted, the reference to it will be changed to the default value defined at the Default Value tab.
Note

Please mind to set the default value at the Default Value tab if the Set Default option is chosen. 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 is to be NULL).

The Reference Qualifier tabThis tab appears when the column has a Reference or List type. In there, you can specify a qualifier for the column. For more information, please refer to the Reference Qualifiers article.ChoiceThe Choice table fieldReference to a dictionary. Its values will be available for the Choice field.The Choice field fieldReference to the specified field of the dictionary. Its values will be available for the Choice field.The Choice type field

Choice field type:

  • Dropdown with None – a drop-down list with None value. If the field is mandatory, then it will be impossible to save the form with None value.
  • Dropdown without None – a drop-down list without None value. Please define a default value for this list type. When this option is selected, the Default value field becomes mandatory.

This field is mandatory for the fields of this type.


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.


Table of Contents
absoluteUrltrue
classfixedPosition