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 code > 225.

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 = 'US'. When this statement is executed the value of the parameter will replace the parameter name. For example if the parameter was set to 'New York' then the statement would execute as: WHERE location_code = 'New York' AND region_code = 'US'.