ramprojectgroup

Allows pre-requisite projects to be defined.

Syntax:

[ DynamicComponentDependency ] ramprojectgroup RAMProjectGroupName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_project_id1 String(32) The project which must come later.
ram_project_id2 String(32) The project 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 projects.
minimum_delay Number (minutes by default) The minimum delay between the projects. 


            ramprojectgroup RAMProjectGroup {{SelectName}} {
               SELECT
                     ..                  ram_project_id1,
                     ..                  ram_project_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 RAMProjectGroup.

RAMProjectGroupName

Syntax:

<Identifier>

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