AX1498

Dependent data lookups

It is possible to configure data lookups so that one data lookup row uses the return value from another row in its query parameters. In order to do this, the data lookup rows must be in separate data sources, and the data sources must be processed in the appropriate order.

If both data sources have different names, then you can simply list them in the appropriate order when configuring the data lookup execution. For example, if a row in data source Data is dependent on a row in data source FileGroup, then you would list the data sources as follows: FileGroup,Data (either with sheet names or without).

This means the FileGroup data source will be executed first, followed by the Data data source. This dependent execution is necessary because the filter criteria statements for the GetData queries use the plan file code returned by the GetFileGroupProperty query.

If both data sources have the same name, then you can use the Order parameter in the [DataLookup] tag to specify the order. This way you can list just one data source name to be executed, but execute both data sources in the appropriate order.

For example, if both data sources are named Info, then you can specify the order of the first data source as 1 and the dependent data source as 2.

Dependent query rows must always be in separate data sources. It is not possible for a row in a data source to be dependent on a row in the same data source. All query rows that belong to the same data source are processed concurrently. The order of rows within the data source is irrelevant.

Dependency on Axiom functions

Data lookup parameters can reference the result of other Axiom functions. However, it is not recommended to reference the result of a GetData function. Instead you should use a separate DataLookup data source and set it up with a [GetData] row. You can then reference the result of that row, and set up the data lookup execution so that the data source with the GetData is executed first.

Generally speaking, if it is possible to return the value using a data lookup and you need to reference the value in another data lookup, then you should set those up as dependent DataLookup data sources rather than using a function and a data source.