As part of an archived table query, the Lookup predicate allows the insertion of an array of values into placeholders in a template Boolean expression. Each row of the array represents a different instance of the same Boolean expression. When the Lookup predicate is processed, all of those individual expressions are combined by logical OR conjunctions into a larger conditional expression.

For example, the following inline Lookup instance:

is equivalent to the following conditional expression:

In this example, the three rows of lookup values are inserted into placeholders in the lookup expression when the query is executed, producing three distinct Boolean expressions, connected by ORs.