This defines the parameter settings for a rule. For each Rule_Parameter row there should always be a Rule_Type_Parameter row with matching parameter id and rule type id. Note that Rule_Type_Parameter is a lookup table so these are pre-existing values and do not need to be included in the input. The Rule_Parameter row can be omitted is the default value on the Rule_Type_Parameter is correct.
Syntax:
[ DynamicComponentDependency ] ruleparameter RuleParameterName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
parameter_id | String(32) | Specifies the parameter_id of the matching Rule_Type_Parameter | |
rule_id | String(32) | Defines the id of the rule this parameter relates to. | |
rule_type_id | String(32) | Specifies the rule_type_id of the matching Rule_Type_Parameter |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
parameter_value | String(32) | Specifies the value of this rule parameter. |
ruleparameter RuleParameter {{SelectName}} { SELECT .. parameter_id, .. rule_id, .. rule_type_id, -- optional columns .. parameter_value FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RuleParameter.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.