activityoperation

Links an operation to a repeatable activity.

Syntax:

[ DynamicComponentDependency ] activityoperation ActivityOperationName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) The identifier of the (repeatable) activity.
operation_id String(32) The identifier of the operation.

Optional columns

Column Name Data Type Description Default Value
earliest_start Date If specified, this is the earliest time that the operation can be carried out for this activity.
last_performed Date If specified, this is the last time (before the current schedule time) that the operation was performed.
latest_start Date If specified, this is the latest time that the operation can be carried out for this activity.


            activityoperation ActivityOperation {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  operation_id,
                  -- optional columns
                     ..                  earliest_start,
                     ..                  last_performed,
                     ..                  latest_start
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityOperationName

Syntax:

<Identifier>


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