objectgroup

This enables an Activity, Activity Type, Resource, Resource_Type to be linked tomore than one Group. Groups are used to control viewing and update accessprivileges to users. There may be instances where for example activities needed to be grouped geographically for dispatching but also need to be organized by cost centers for reporting.

Syntax:

[ DynamicComponentDependency ] objectgroup ObjectGroupName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Optional columns

            objectgroup ObjectGroup {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  group_id,
                  -- optional columns
                     ..                  activity_id,
                     ..                  activity_type_id,
                     ..                  resource_id,
                     ..                  resource_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ObjectGroupName

Syntax:

<Identifier>

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