ramprojecttemplate

Pre-defined projects from which other projects may be created.

Syntax:

[ DynamicComponentDependency ] ramprojecttemplate RAMProjectTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.

Optional columns

Column Name Data Type Description Default Value
description String(2000) A description of the template.
exclusive_resource Number (0 = False, 1 = True) Whether the project requires a single resource to work on all child projects (SCHEME only)
maximum_elapsed_time Number (minutes by default) The maximum time the project is allowed to take.
ram_project_template_id String(32) The id of the parent project template (parent projects must be of type SCHEME).
ram_project_type_id String(32) The id of the project type.
ram_role_id String(32) The role required for this template. 


            ramprojecttemplate RAMProjectTemplate {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  description,
                     ..                  exclusive_resource,
                     ..                  maximum_elapsed_time,
                     ..                  ram_project_template_id,
                     ..                  ram_project_type_id,
                     ..                  ram_role_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMProjectTemplateName

Syntax:

<Identifier>

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