resourcepreference

This instructs the scheduler to either not consider a resource/resource type for anactivity, activity type or location, or to only consider specified resources/resourcetypes, or to prefer resources on a sliding scale of preference from any valuesgreater than 0 and less than 1.

Syntax:

[ DynamicComponentDependency ] resourcepreference ResourcePreferenceName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Specifies the unique id for the Resource Preference.
preference Double Provides the preference value.

Optional columns

Column Name Data Type Description Default Value
activity_id String(32) Specifies the activity to which the preference applies.
activity_type_id String(32) Specifies the activity type to which the preference applies.
description String(2000) Provides a description of the Resource Preference, which may be shown in the Scheduling Workbench
location_id String(32) Specifies the location to which the preference applies.
resource_id String(32) Specifies the resource to which the preference applies.
resource_type_id String(32) Specifies the resource type to which the preference applies. 


            resourcepreference ResourcePreference {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  preference,
                  -- optional columns
                     ..                  activity_id,
                     ..                  activity_type_id,
                     ..                  description,
                     ..                  location_id,
                     ..                  resource_id,
                     ..                  resource_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ResourcePreferenceName

Syntax:

<Identifier>

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