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

Compare with Current View Page History

« Previous Version 2 Next »

Date


This field type stores the date in the following format: YYYY-MM-DD to within 1 day and not specifying the time of the day. The size of the data stored is 4 bytes.

In SimpleOne interface, it is displayed as an input field with a date picker.

To create a date type field, preform the steps described in Create a column.

A date can be written in three different ways:

  • YYYY-MM-DD (ISO 8601 format)
  • DD.MM.YYYY
  • MM/DD/YYYY

Available symbols in this field:

  • Numbers
  • Slash ( / )
  • Hyphen ( - )
  • Dot ( . )

Date elements are validated to meet the following criteria:

ElementRangeComment
Day[01..31]The value specified should not exceed this range.
Month[01..12]The value specified should not exceed this range.
Year[0001..9999]The value specified should not exceed this range.

Date Time


This field type stores the timestamp measured in seconds.

In SimpleOne interface, it is displayed as an input field with a date and time picker.

The datetime can be written in the ISO 8601 format like shown below:

YYYY-MM-DD HH:MM:SS

Datetime elements are validated to meet the following criteria:

ElementRangeComment
Second[00..59]

The value specified should not exceed this range.

Minute[00..59]

The value specified should not exceed this range.

Hour[00..23]The value specified should not exceed this range.
Day[01..31]The value specified should not exceed this range.
Month[01..12]The value specified should not exceed this range.
Year[1900..2099]The value specified should not exceed this range.


Date Time Specific


This field type stores the timestamp measured in seconds.

In SimpleOne interface, it is displayed as an input field with a date and time picker.

This field type is mainly used in Schedules

In contrast to the Date Time field type, this field type uses the UTC offset parameter defined in the system timezone. 

The datetime can be written in the ISO 8601 format like shown below:

YYYY-MM-DD HH:MM:SS

Datetime elements are validated to meet the following criteria:

ElementRangeComment
Second[00..59]The value specified should not exceed this range.
Minute[00..59]The value specified should not exceed this range.
Hour[00..23]The value specified should not exceed this range.
Day[01..31]The value specified should not exceed this range.
Month[01..12]The value specified should not exceed this range.
Year[1900..2099]The value specified should not exceed this range.

Create a date or datetime column

This column database value can contain all kinds of symbols. If the string length is not set, then it is limited to 80 symbols.

To create a choice column, please complete the following steps:

  1. Navigate to the System Definition → All Tables.
  2. Open the table for which you want to create a column.
  3. Scroll down to the Related Lists area and click on the Columns tab.
  4. Click New and fill in the fields.
  5. Click Save or Save and Exit to apply changes.


You can also open the form this way:

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

Please note that in this case, you will need to fill in the Table field manually.

Column form fields

FieldMandatoryDescription
TableY

Specify the table name that will be a parent for this column. This field is a reference to the Tables dictionary (sys_db_table).

Column TypeY

Specify a column type.

TitleYA 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 NameY

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.

CommentsNWrite a comment with the additional information.
ActiveN

Select this checkbox, and customizing of this field displayed on the form and list will be possible.

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

Read OnlyNSelect this checkbox to make the field read-only.
MandatoryNSelect this checkbox to make the field mandatory.
Full Text SearchNSet this attribute equal to TRUE to make it possible to perform a Global Search against the current column.
Display by RefN

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.

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

UniqueNWhen turned on, no way to add a record with a value of this field, if a record with the same value already exists.
Default Value tab
Default ValueN

The value of a choice option to be populated authomatically by default.

Use Dynamic DefaultNSelect this checkbox to specify the Dynamic Default field.
Dynamic DefaultN

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.

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

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


  • No labels