customexceptiondata

This defines the custom exceptions data to be used in the Scheduling Workbench.

Syntax:

[ DynamicComponentDependency ] customexceptiondata CustomExceptionDataName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
custom_exception_id String(32) Specifies the id of the custom exception this relates to.
label String(40) Defines the label to be used.
value String(256) Defines the value for the label.

Optional columns

Column Name Data Type Description Default Value
sequence Number Specifies the sequence in which the data columns will be displayed. 1 


            customexceptiondata CustomExceptionData {{SelectName}} {
               SELECT
                     ..                  custom_exception_id,
                     ..                  label,
                     ..                  value,
                  -- optional columns
                     ..                  sequence
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

CustomExceptionDataName

Syntax:

<Identifier>

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