AX1472

GetData data lookup

You can use GetData rows in a DataLookup data source to return data from a table, given a column name, a criteria statement, and a table name.

The GetData data lookup supports the same query parameters as the GetData function, and can be used as a substitute for this function to improve file performance. (missing or bad snippet)

To create a GetData data lookup, add a [GetData] 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.

GetData parameters

[GetData] 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.

(missing or bad snippet)(missing or bad snippet)

Example

The following screenshot of a DataLookup data source shows several GetData examples. Some optional parameter columns are omitted for space.

For more examples of GetData use, see GetData function. The same examples work for both approaches. To use a function example in a DataLookup data source, you would place the applicable function parameters in the corresponding parameter columns.