ramresourcepreference

Defines a preference between a resource or resource type and an activity type.

Syntax:

[ DynamicComponentDependency ] ramresourcepreference RAMResourcePreferenceName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.
preference Double The preference value (0-1).
ram_activity_type_id String(32) The activity type to which this applies.

Optional columns

Column Name Data Type Description Default Value
description String(2000) A description for this resource preference.
ram_resource_id String(32) The resource to which this applies.
ram_resource_type_id String(32) The resource type to which this applies. 


            ramresourcepreference RAMResourcePreference {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  preference,
                     ..                  ram_activity_type_id,
                  -- optional columns
                     ..                  description,
                     ..                  ram_resource_id,
                     ..                  ram_resource_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMResourcePreferenceName

Syntax:

<Identifier>

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