In SimpleOne, the date and datetime columns are commonly used in schedules, business rules, task management, logs, etc.
This column type stores the date in the following format: YYYY-MM-DD and does not specify the time of the day. The data stored is 4 bytes.
In SimpleOne interface, it is displayed as an input field with a date picker.
A date can be written in three different ways:
Available symbols in this field:
To create a date type field, perform the steps described in Creating a datetime column section of this article.
Date elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
Day | [01..31] | The value specified should not exceed this range. |
Month | [01..12] | The value specified should not exceed this range. |
Year | [1900...2100] | The value specified should not exceed this range. |
This column type is used for storing time in the ISO 8601 format: HH:MM:SS. Timezone is not taken into account. The date is not stored. Size of the stored data – 8 bytes.
The allowed symbols are numbers and a colon ( : ).
Time stamp elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
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. |
This column 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
To create a Date/Time type field, perform the steps described in Creating a datetime column section in this article.
Datetime elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
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..2100] | The value specified should not exceed this range. |
This column 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. |
To create a Date/Time Specific field type, perform the steps described in Creating a datetime column section in this article.
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:
Element | Range | Comment |
---|---|---|
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..2100] | The value specified should not exceed this range. |
Role required: admin. |
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 column of datetime type, please complete the following steps:
You can also open the form this way:
Please note that in this case, you will need to fill in the Table field manually. |
Field | Mandatory | Description |
---|---|---|
Table | Y | Specify the table name that will be a parent for this column. This field is a reference to the Tables (sys_db_table) dictionary. |
Column Type | Y | Specify a column type. |
Title | Y | A 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. |
Comments | N | Write a comment with the additional information. |
Active | N | Select this checkbox to activate or deactivate the column. If unselected, then such a 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. |
Mandatory | N | Select this checkbox to make the field mandatory. |
Full Text Search | N | Set this attribute equal to 'true' to make it possible to perform a Global Search against the current column. |
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. 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 | N | When selected, 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 Value | N | The value of a choice option to be populated authomatically by default. |
Use Dynamic Default | N | Select this checkbox to specify the Dynamic Default field. |
Dynamic Default | N | 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'.
|