Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
In SimpleOne, the date and datetime columns are commonly used in schedules, business rules, task management, logs, etc.
Date
This The database stores values of the column type stores the date in the following ISO 8601 format: YYYY-MM-DD and does not specify the time of the day. The stored data stored size is 4 bytes.
In the SimpleOne interface, it is displayed as an input field with a date picker.
Image Modified
A date must have the ISO 8601 format: YYYY-MM-DD
Available symbols in this fieldAccording to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
To create a date type field, perform the steps described in Creating a datetime column section of this article.
Date elements are validated to Date elements should 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 | [19001000...2100] | The value specified should not exceed this range. |
To create a Date column, see the Create Columns article.
Time
This column type is used for storing to store time in the ISO 8601 format: HHhh:MMmm:SSss. Timezone is not taken into account. The date is not stored. Size The size of the stored data – 8 – 8 bytes.
The allowed symbols are numbers and a colon ( : ).
Image Removed
Image Added
According to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Timestamp elements should 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. |
To create a Time column, see the Create Columns article.
Date/Time
This column type stores the timestamp time measured in seconds. Date and time are stored in the ISO 8601 format: YYYY-MM-DD hh:mm:ss.
In the SimpleOne interface, it is displayed as an input field with a date and time picker.
Image Removed
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.
Image Added
According to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Date and time elements should 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 | [19001000..21009999] | The value specified should not exceed this range. |
To create a Date/Time column, see the Create Columns article.
Date/Time Specific
This column type stores the timestamp time measured in seconds. Date and time are stored in the ISO 8601 format: YYYY-MM-DD hh:mm:ss.
In the SimpleOne interface, it is displayed as an input field with a date and time picker.
Image Removed
Image Added
This field type is mainly used in Schedules.
Tip |
---|
In contrast to the Date/Time field type, this the Date/Time Specific 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
That is, the date and time is stored in the database as it is, without any offset. |
Date and time elements should 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 | [19001000..21009999] | The value specified should not exceed this range. |
Creating a 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
column of datetime type, please complete the following steps:- Navigate to the System Definition → All Tables.
- Open the table for which you want to create a column.
- Scroll down to the Related Lists area and click on the Columns tab.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Info |
---|
You can also open the form this way:
Please note that in this case, you will need to fill in the Table field manually. |
Column form fields
Specify the table name that will be a parent for this column. This field is a reference to the Tables (sys_db_table) dictionary.
Specify a column type.
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.
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.
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.
The value of a choice option to be populated authomatically by default.
Date/Time Specific column, see the Create Columns article.
Days of week
This column type allows for selecting one or more days of the week.
In SimpleOne interface, it is displayed as a drop-down list with checkboxes. One or more days can be selected.
Click Select all to add all days of the week. Click Select all once again to clear the field.
Image Added
Technically, the field stores a numeric value or a sum of values. The size of data stored is 2 bytes. Each day of the week is assigned a value:
Monday = 1
Tuesday = 2
Wednesday = 4
Thursday = 6
Friday = 16
Saturday = 32
Sunday = 64
The minimum field value is 0 (days are not selected). The maximum value of the field is 127 (all days selected). For example, if Tuesday (2) and Wednesday (4) are selected, the field value is 6
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'.
.
Table of Contents | ||||||
---|---|---|---|---|---|---|
|