Parameters for linked table queries

The query for a linked table determines which data from an external source to include in the table. You can include parameters in the query, and, as you configure a table lookup data reference that uses the linked table, you can specify parameter values. This enables you to use a single linked table to obtain different results in every table lookup data reference that uses it.

Using parameters in a linked table query is useful, for example, to limit the number of rows returned from a very large external table. You can add conditions and parameters to return more targeted results, such as all rows that include a device or manufacturer ID number, specific for each table lookup data reference.

As you configure a linked table in the Table Link window, you can add table parameters to its query and set default values for them. Then, in the Table Lookup Data Reference window, as you define a data reference using the linked table, you can enter table parameter values specific for that data reference. You can also supply parameter values programmatically using AF SDK. Parameter values can be specific values or come from other attribute values or from pre-defined substitution variables, such as %Element%.