urlparameter

This specifies a parameter to be associated with a custom URL. The value of the parameter can be sourced from a particular table(e.g. Activity or Resource). See example below:

Syntax:

[ DynamicComponentDependency ] urlparameter URLParameterName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
custom_url_id String(32) Specifies the owning URL
sequence Number Defines the sequence in the URL.

Optional columns

Column Name Data Type Description Default Value
custom_parameter Number Defines the custom url parameter to be sourced from one of the entity custom url 'linking' tables.
parameter_value String(2000) Provides the parameter value.
parameter_value_table String(32) Gives the name of the table from which the parameter is to be retrieved. 


            urlparameter URLParameter {{SelectName}} {
               SELECT
                     ..                  custom_url_id,
                     ..                  sequence,
                  -- optional columns
                     ..                  custom_parameter,
                     ..                  parameter_value,
                     ..                  parameter_value_table
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

URLParameterName

Syntax:

<Identifier>

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