Defines a period or periods of time, possibly recurring.
Syntax:
[ DynamicComponentDependency ] ramtimepattern RAMTimePatternName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
base_time | Date | The start time, or time from which the template should be applied. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
duration | Number (minutes by default) | If a single period is required the duration can be specified here instead of using the template. | |
ram_time_pattern_template_id | String(32) | The template to use to determine the pattern. | |
time_zone | String(64) | The time zone to use when applying this pattern. |
ramtimepattern RAMTimePattern {{SelectName}} { SELECT .. id, .. base_time, -- optional columns .. duration, .. ram_time_pattern_template_id, .. time_zone FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMTimePattern.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.