rammodellingpattern

Defines a modelling pattern to use when planning cyclic work. See

Syntax:

[ DynamicComponentDependency ] rammodellingpattern RAMModellingPatternName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) The id of the modelling pattern.
interval Number (minutes by default) See Modelling_Pattern in Scheduling Schema.

Optional columns

Column Name Data Type Description Default Value
same_resource Number (0 = False, 1 = True) See Modelling_Pattern in Scheduling Schema. False
step Number See Modelling_Pattern in Scheduling Schema. 1
description String(2000) See Modelling_Pattern in Scheduling Schema.
leeway Number (minutes by default) See Modelling_Pattern in Scheduling Schema.
leeway_before Number (minutes by default) See Modelling_Pattern in Scheduling Schema.
leeway_percentage Double See Modelling_Pattern in Scheduling Schema.
leeway_percentage_before Double See Modelling_Pattern in Scheduling Schema.
min_delay Number (minutes by default) See Modelling_Pattern in Scheduling Schema.
value_multiplier Double See Modelling_Pattern in Scheduling Schema. 


            rammodellingpattern RAMModellingPattern {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  interval_,
                  -- optional columns
                     ..                  same_resource,
                     ..                  step,
                     ..                  description,
                     ..                  leeway,
                     ..                  leeway_before,
                     ..                  leeway_percentage,
                     ..                  leeway_percentage_before,
                     ..                  min_delay,
                     ..                  value_multiplier
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling RAMModellingPattern.

RAMModellingPatternName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.