Defines periods of time to be applied to a base time.
Syntax:
[ DynamicComponentDependency ] ramtimepatterntemplate RAMTimePatternTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
recurrence_days | Number | The number of days over which the pattern should occur. | |
recurrence_months | Number | The number of months over which the pattern should occur. | |
recurrence_period | Number (minutes by default) | The time period over which the pattern should recur. |
ramtimepatterntemplate RAMTimePatternTemplate {{SelectName}} { SELECT .. id, -- optional columns .. recurrence_days, .. recurrence_months, .. recurrence_period FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMTimePatternTemplate.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.