Defines a list of allowed values for attributes with the data type DOMAIN.
Syntax:
[ DynamicComponentDependency ] ramattriballowedvalue RAMAttribAllowedValueName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
ram_attribute_id | String(32) | The id of the attribute. | |
value | String(100) | A value the attribute is allowed to be. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | A decription of the value. | |
sequence | Number | The order in which to display the allowed value. |
ramattriballowedvalue RAMAttribAllowedValue {{SelectName}} { SELECT .. ram_attribute_id, .. value, -- optional columns .. description, .. sequence FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMAttribAllowedValue.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.