Token examples

In this example, the DIY query takes the criteria that is specified in the Description field and replaces the [%%HEADER.DESCRIPTION] token at run time.

SELECT ITEM_CODE FROM FSITEM WHERE DESCRIPTION LIKE [%%HEADER.DESCRIPTION]

This enables the query to have some dynamic context about the currently executing query. Optionally, you can indicate whether to use the Min or Max criteria field as the source for the replacement token value.

[%%STATUS.HOLDCODE]

[%%STATUS.HOLDCODE.MIN]

[%%STATUS.HOLDCODE.MAX]

The first two are the same because "MIN" is the default.