Specifications

Using SQL Select
176 InfoMaker
Dynamically selecting, sorting, and grouping data
Selection, sorting, and grouping criteria that you define in the SQL Select
painter are added to the SQL statement and processed by the DBMS as part of
the retrieval. You can also define selection, sorting, and grouping criteria that
are created and processed dynamically by InfoMaker after data has been
retrieved from the DBMS.
For more information, see Chapter 9, “Filtering, Sorting, and Grouping
Rows.”
Defining WHERE
criteria
You can limit the rows that are retrieved into the report by specifying selection
criteria that correspond to the
WHERE clause in the SELECT statement.
For example, if you are retrieving information about employees, you can limit
the employees to those in Sales and Marketing, or to those in Sales and
Marketing who make more than $50,000.
❖ To define WHERE criteria:
1 Click the Where tab to make the Where view available (or select
View>Where if the Where view is not currently displayed).
Each row in the Where view is a place for entering an expression that
limits the retrieval of rows.
2 Click in the first row under Column to display columns in a drop-down
list, or select Columns from the pop-up menu.
3 Select the column you want to use in the left-hand side of the expression.
The equality (
=) operator displays in the Operator column.
Using a function or retrieval argument in the expression
To use a function, select Functions from the pop-up menu and click a listed
function. These are the functions provided by the DBMS.
To use a retrieval argument, select Arguments from the pop-up menu. You
must have defined a retrieval argument already.
4 (Optional) Change the default equality operator.
Enter the operator you want, or click to display a list of operators and
select an operator.