QAD Data Warehouse Designer builds a select statement (SELECT * from [table name]). The Where or Group clauses are those clauses that immediately follow the from verb of the select statement. For example: SELECT * from Customer WHERE rownum < 300.

Parameter values can be in-line replaced and included in the where clause. Prefix the parameter name with a '$P' and add a trailing '$'. For example if we have a parameter called SALES_LOCATION_CODE we could construct a statement such as WHERE location_code = '$PSALES_LOCATION_CODE$' AND region_code = 'NZ'. When this statement is executed the value of the parameter will replace the parameter name. For example if the parameter was set to 'Auckland' then the statement would execute as: WHERE location_code = 'Auckland' AND region_code = 'NZ'.