Criteria Tab
- Add tables, views and synonyms to the Model Area.
- In these tables, views and synonyms, select the columns you want to add to the Criteria tab. Only Selected columns appear on the Criteria tab.
|
|
TIP: To rearrange the order of the columns on the Criteria tab, drag and drop them left or right. |
| Field | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Only fetch unique records |
Select to apply the DISTINCT command to the query. | ||||||||||
|
Schema |
The schema cannot be edited. | ||||||||||
|
Null Value Subst. |
Double click in the cell to enter a value to substitute for any null values. To clear the cell, highlight it and press Delete. | ||||||||||
|
Aggregate F. |
Double click in the cell to select an aggregate column function, such as Average, Count, Max, Min, or Sum. To clear the cell, highlight it and press Delete. | ||||||||||
|
Where Cond. |
Double-click in the cell to open the WHERE Definition dialog.
| ||||||||||
|
Or |
Double-click in the cell to open the WHERE Definition dialog (as above). This WHERE criteria will be OR'ed together with the above WHERE criteria. If you want to AND multiple column criteria together, then select Expert from the WHERE Definition dialog. For more information, see Global WHERE Conditions Window. | ||||||||||
|
Group By |
Double-click in the cell to select it as a GROUP BY column. A number in parentheses indicates the order of the columns in the GROUP BY clause. See also The Having Cond. cell. To clear the cell, highlight it and press Delete. | ||||||||||
|
Having Aggregate |
Double click in the cell to select an aggregate column function (such as Average, Count, Max, Min, or Sum) for the HAVING clause. This allows for the following type of query: SELECT emp.job_id FROM employee emp GROUP BY emp.job_id HAVING ((AVG (emp.salary) > 1500)) To clear the cell, highlight it and press Delete. | ||||||||||
|
Having Cond. |
Double click in the cell to open the GROUP BY Definition dialog.
To clear the cell, highlight it and press Delete. | ||||||||||
|
Sort |
Double click in the cell to sort this column as Ascending, Descending, or no sort. To clear the cell, highlight it and press Delete. | ||||||||||
|
Visible |
Double click in the cell to have it be visible / hidden. When visible the column is returned in the column list. | ||||||||||
|
Field Alias |
Double click in the cell to change the field name alias. | ||||||||||
|
Table Alias |
Double click in the cell to enter a value for the table alias. To clear the cell, highlight it and press Delete. |
Right-click over the Criteria grid:
| Menu | Description |
|---|---|
|
Suppress Current Column |
Remove this column from the query |
|
Best Fit (All Columns) |
Set the column width of the Criteria grid to show all text |
|
Default Width (All Columns) |
Set the column width of the Criteria grid to the default width |
|
Copy Query Grid Image to Clipboard |
Copy the Criteria grid to the clipboard |