Page History

There are two types of objects in our the system: tables and columns. Tables consist of columns . Both of these objects can be created via the agent interfacethat store different information depending on the type.

Tip
Role required: admin.

You can create a column in two ways:

via table forms.
by adding a record to the All Columns (sys_db_column) table.

Info
Columns You can be added add columns only to existing tables.

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

Navigate to System Definition Settings→ All Tables.
Choose Open the table you need to add a column to.
Scroll down to In the Related Lists area and , select the Column Columns tab.
Click New and fill in the formfields.
Click Save or Save and Exitexit to apply the changes.

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

Navigate to System DefinitionSettings → All Columns.
Click New and fill in the formfields.
Click Save or Save and Exitexit to apply the changes.

Tip

A column can be configured from any form it is displayed on. To do so, complete the following steps:

Open any record in the table that contains the column you need to modify.

Column attributes

Right-click the title of the required field → Configure field.

Column form fields

Field

Attribute

	Mandatory	Description
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

added to them.

This field references

to the

the Tables (sys_db_table) dictionary.

After the record is saved, this field becomes read-only.

Column

Type

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, please refer to the

. See Column Types article to learn more.

After the record is saved, this field becomes read-only.

Title

Y

A

Specify a column title displayed

on

in the

form

interface. It

is preferred to

should be

sensible

meaningful and human-readable. You can use Latin

,

or Cyrillic letters, [0..9] numbers and the underscore symbol ( _ )

are allowed

.

The Title field can be translated to other languages.

Column

Name

name
Anchor
column_name
column_name

Y

A system

System column name.

It is preferred to be human-readable and keep the kind of stored data. Latin letters,

This field is populated automatically, depending on the Title entered, and becomes read-only after the record is saved. Latin letters, [0..9] numbers, and the underscore symbol ( _ ) are allowed. The system name must begin with a letter.

System column names are used in scripts.

Note

This field is populated automatically depending on the title entered. Also, column

Column name prefixes

may be

are added, depending on the

column name creating

circumstances listed below:

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:
Title Column name
New column c_new_column
If you create a column within a table related to non-vendor applications, then the prefix is not added.

Example for case 1


Comments	N	Add some comments that describe the column.

Column titleNew column nameNew columnc_new_column


Active	N	Select

this

the checkbox to activate

or deactivate

the column.

If

unselected, such field will be

not selected, the column is not available

for choosing in Form Layout or List layout

in the form layout or list layout configuration.

Read

Only

only

N

Select

this

the 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

This checkbox is hidden if the Column type is set to Journal Input.

Mandatory

N

Select

this

the checkbox to make the field mandatory.

Full

Text Search

text search

N

Select

this

the checkbox to make it possible to perform

a Global Search

a global search against the

current

column values.

InfoPlease note that after activating this attribute

When selected, 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

are created for the column values.

Display by

Ref

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

Select the checkbox to display the column values instead of record IDs in the reference fields that refer to the Table.

A table can have only one column with this checkbox selected. If another column is set as a displayed field, the previously selected Display by ref checkbox is cleared.

Unique

N

When selected, there is no way to add a record with a value of this field,

Select the checkbox to prevent from creating a new record in the Table if a record with the same value in this column 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

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

section

The presence of this section on the column form and the field available to vary depending on the Column type selected.

Attribute

Field

Mandatory	Description
Max

Length

length

N

Specify the maximum value length for

this column

the value. The value length cannot exceed the allowed length for the specified data type. These limitations, if any, are specified in the Column Types article.

Expand

title	The field is displayed in the section for the following column types

Encrypted Password
HTML
Journal Input
Password
Record Class
Script
String
Template
Text
Translated text
URL

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 Fields article to learn more about this column type.

Field

Mandatory

Description

Choice table

N

Specify a table that contains the choice options.

Choice field

Y

Specify a column of the Choice table to use its values as choice options.

Choice type

Y

Select the list type. Available options:

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

Default Value Tab

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

Extra attributes

N

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

Code Block

language	js
theme	Eclipse

choice_decorator=radio

Image Added

Conditions column type

Field Mandatory Description

Dependent on column Y Specify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary to build conditions.

Extra attributes

N

Specify the extended condition operators. For example:

extended_operators=VALCHANGES;CHANGESFROM;CHANGESTO;IS_CALCULATED

These operators become available for use in the condition builder.

Reference column type

See the Reference Fields article to learn more about this column type.

Field

Mandatory

Description

Reference

Y

Specify a table with the values you need.

On delete

N

Define 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 will be equal to null).

Warning

When deleting a record A, an update error of a record B will occur if the record has a column that references the record A is mandatory and the Action on delete for this column is Set NULL.

Code Block

language	text
title	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 value – the reference to the column will be changed to the default value defined in the Default Value section.

Note
Make sure that you set the default value on the Default Value tab if the Set default value 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

Field

Mandatory

Description

Extra attributes

N

Specify the maximum image width and height. For example:

No Format
width=1600 height=800

Field Name and Template column types

Field	Mandatory	Description
Dependent on column	Y	Specify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary to build conditions.

Default Value section
Anchor
default value
default value

The Default Value section The Default Value tab is available for all column types.

Attribute	Mandatory	Description
Default

Value

value

Y/N

Specify a default value that will be populated automatically to the field when

creating

a new record is created.

This field may be specified by a Javascript scenario as well.

The field is mandatory when the Choice type is Dropdown without --None-- (specify a default value).

Use dynamic default

Image Removed

Use Dynamic Default

N

Select

this

the checkbox if you

want to

want to generate the default value dynamically.

Dynamic

Default

default

N

This field appears only when the Use

Dynamic Default

dynamic default attribute is set to

'

true

'

.

Select the script from the Dynamic Default Values (sys_default_value_dynamic)

dictionary

table, so its execution

result will be

results are automatically calculated and entered into this field. This value will be the default value for the column specified.

Note
The script must

preliminary be

preliminarily be created in the Dynamic Default Values (sys_default_value_dynamic)

dictionary

table; otherwise, you will not be

not

able to

choose

select it.
You can

choose

select only active scripts (the Active

attribute

checkbox is

equal to Yes

selected).

Reference Qualifier

Tab InfoThe Reference Qualifier tab

section

The section appears for the following column types:

Field Name
List
Reference

Field	Mandatory	Description
Reference

Qualifier Type

qualifier type

N

Select the type of reference qualifier. Available options:

Simple
Dynamic

Reference

Qualifier Condition

qualifier condition

N

Configure the filters using the

Condition Builder

condition builder.

This field appears when the Reference

Qualifier Type

qualifier type value is Simple.

Dynamic

Reference Qualifier

reference qualifier

N

Select the dynamic reference qualifier from the list.

This field appears when the Reference

Qualifier Type

qualifier type value is Dynamic.

Reference

Qualifier Fixed

qualifier fixed

N

Select

this

the checkbox to fix filters in the breadcrumbs

in

of the

dictionary

table when using this field. This functionality

will block using the Condition Builder functionality in this field

blocks the use of the condition builder.

Table of Contents

maxLevel	3
absoluteUrl	true
class	fixedPosition
printable	false

Page tree

Versions Compared

Old Version 11

New Version Current

Key

Column attributes

Column form fields

Table

Column

type

Title

Column

name
Anchor
column_name
column_name

Comments

Active

Read

only

Mandatory

Full

text search

Display by

ref

Unique

Type Specification

section

Default Value Tab

Default Value section
Anchor
default value
default value

Reference Qualifier

section

Page tree

Page History

Versions Compared

Old Version 11

New Version Current

Key

Column attributes

Column form fields

Table

Column

type

Title

Column

name Anchorcolumn_namecolumn_name

Comments

Active

Read

only

Mandatory

Full

text search

Display by

ref

Unique

Type Specification

section

Default Value Tab

Default Value section Anchordefault valuedefault value

Reference Qualifier

section

name
Anchor
column_name
column_name

Default Value section
Anchor
default value
default value