applicationdataset

This table is used to exclude the processing of particular datasets by a given application type.

Syntax:

[ DynamicComponentDependency ] applicationdataset ApplicationDatasetName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
application_type_id String(32) Defines the id of the application the entry relates to.
dataset_id String(32) The dataset the application can or cannot process.
organisation_id Number Defines the id of the organisation for this dataset

Optional columns

Column Name Data Type Description Default Value
disallowed Number (0 = False, 1 = True) If true the application will not process the dataset True 


            applicationdataset ApplicationDataset {{SelectName}} {
               SELECT
                     ..                  application_type_id,
                     ..                  dataset_id,
                     ..                  organisation_id,
                  -- optional columns
                     ..                  disallowed
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ApplicationDatasetName

Syntax:

<Identifier>

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