AX1805
GetPlanItemValue data lookup
You can use GetPlanItemValue rows in a DataLookup data source to return values from the plan code table, for the current plan code. It is intended to be used in plan files.
(missing or bad snippet)The GetPlanItemValue data lookup supports similar query parameters as the GetPlanItemValue function, and can be used as a substitute for this function to improve file performance. (missing or bad snippet)
To create a GetPlanItemValue data lookup, add a [GetPlanItemValue] row to a DataLookup data source and add the appropriate parameter columns. For more information on creating the DataLookup data source, see Creating DataLookup data sources.
GetPlanItemValue parameters
[GetPlanItemValue] rows use the following parameter columns. Within the DataLookup control row, these parameter names must be placed in square brackets—for example, [ColumnName]. The parameters can be placed in any order.
Example
The following screenshot of a DataLookup data source shows several GetPlanItemValue examples:
