How to limit data in Request Types with SQL-like Criteria

To limit the data that is presented in a list box on a request, you can use SQL-like criteria as part of the design for a particular field. This is done via the "Selection" area of the Field Definition screen.

For example:

To limit an account list to customers and prospects use
c.cmp_type in ('C', 'P')

To limit an item list to a given assortment use
items.assortment in (0,1)

To limit to a range of items use
items.itemcode like '51%' (this will pull all items that begin with 51)

To limit to a single item use
items.itemcode like '0009'