DataFunctionUnion
Union of data functions of different type.
Fields
| Field | Type | Number | Description |
|---|---|---|---|
year | DataFunctionUnion.YearData (oneof data) | 1 | Gets the year of a date or timestamp value (e.g. 2004). |
month | DataFunctionUnion.MonthData (oneof data) | 2 | Gets the month of a date or timestamp value (e.g. "02"). |
year_and_month | DataFunctionUnion.YearAndMonthData (oneof data) | 3 | Gets the year and month of a date or timestamp value (e.g. "2004-02"). |
date | DataFunctionUnion.DateData (oneof data) | 4 | Gets the date part of a date or timestamp value (e.g. 2004-02-15). |
days_from | DataFunctionUnion.DaysFromData (oneof data) | 5 | Gets the difference of the current timestamp and a specified date or timestamp value as the number of days (e.g. 8 or -10). |
days_to | DataFunctionUnion.DaysToData (oneof data) | 6 | Gets the difference of a specified date or timestamp value and the current timestamp as the number of days (e.g. 10 or -8). |
integer_segment | DataFunctionUnion.IntegerSegmentData (oneof data) | 7 | Gets the integer segment of a value (an integer number or a real number) based on a defined segment size. |
left_characters | DataFunctionUnion.LeftCharactersData (oneof data) | 8 | Gets a defined amount of left characters from a text or typed value. |
initial_character_group | DataFunctionUnion.InitialCharacterGroupData (oneof data) | 9 | Gets an initial character group from a text or typed value. |
Used in fields
DataFunctionCall.data-- The data.
Nested message NoOpData
Returns the data without modifying it.
Full name: MFiles.DataFunctionUnion.NoOpData
No fields.
Nested message YearData
Gets the year of a date or timestamp value (e.g. 2004).
Full name: MFiles.DataFunctionUnion.YearData
No fields.
Nested message MonthData
Gets the month of a date or timestamp value (e.g. "02").
Full name: MFiles.DataFunctionUnion.MonthData
No fields.
Nested message YearAndMonthData
Gets the year and month of a date or timestamp value (e.g. "2004-02").
Full name: MFiles.DataFunctionUnion.YearAndMonthData
No fields.
Nested message DateData
Gets the date part of a date or timestamp value (e.g. 2004-02-15).
Full name: MFiles.DataFunctionUnion.DateData
No fields.
Nested message DaysFromData
Gets the difference of the current timestamp and a specified date or timestamp value as the number of days (e.g. 8 or -10).
Full name: MFiles.DataFunctionUnion.DaysFromData
No fields.
Nested message DaysToData
Gets the difference of a specified date or timestamp value and the current timestamp as the number of days (e.g. 10 or -8).
Full name: MFiles.DataFunctionUnion.DaysToData
No fields.
Nested message IntegerSegmentData
Gets the integer segment of a value (an integer number or a real number) based on a defined segment size.
Full name: MFiles.DataFunctionUnion.IntegerSegmentData
| Field | Type | Number | Description |
|---|---|---|---|
segment_size | int32 | 1 | The size of the value range of one segment. Typically 1000. |
Nested message LeftCharactersData
Gets a defined amount of left characters from a text or typed value.
Full name: MFiles.DataFunctionUnion.LeftCharactersData
| Field | Type | Number | Description |
|---|---|---|---|
count | uint32 | 1 | The number of characters to extract from the beginning of the value. |
Nested message InitialCharacterGroupData
Gets an initial character group from a text or typed value.
Full name: MFiles.DataFunctionUnion.InitialCharacterGroupData
| Field | Type | Number | Description |
|---|---|---|---|
lcid | uint32 | 1 | The locale used to form the initial character group of a string. 0 uses the locale of the server. |