ramprojecttemplategroup

Defines pre-requisites between template projects.

Syntax:

[ DynamicComponentDependency ] ramprojecttemplategroup RAMProjectTemplateGroupName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_project_template_id1 String(32) The project template which must come later.
ram_project_template_id2 String(32) The project template which must come first.

Optional columns

Column Name Data Type Description Default Value
delay_from_start Number (0 = False, 1 = True) Determines whether the delays are applied from the start of the first project or the end.
maximum_delay Number (minutes by default) The maximum delay between the project templates.
minimum_delay Number (minutes by default) The minimum delay between the project templates. 


            ramprojecttemplategroup RAMProjectTemplateGroup {{SelectName}} {
               SELECT
                     ..                  ram_project_template_id1,
                     ..                  ram_project_template_id2,
                  -- optional columns
                     ..                  delay_from_start,
                     ..                  maximum_delay,
                     ..                  minimum_delay
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMProjectTemplateGroupName

Syntax:

<Identifier>

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