Grid Pane
In the Grid pane, you can specify the attributes of the query. Attributes
like Field Names, Group By operations and Where Clauses can be specified
in this element of SQL Query Builder.
Grid pane columns
|
Column |
Description |
|
Column |
Displays the name of the
column used for the query or the expression for a computed column. |
|
Alias |
Specifies an alternate name
for a column. |
|
Table |
Specifies the name of the
table for the associated column. |
|
Output |
Specifies whether a column
appears in the query output. If you do not want the search columns or
expressions to appear in the query output, clear the Output column for
each search column or expression to remove them as output columns. |
|
Sort Type |
Specifies that the column
is used to sort the results. You can choose ascending or descending sorting. |
|
Sort Order |
Specifies the sort priority
for columns used to sort the results. |
|
Group By |
Specifies that the associated
data column is being used to create an aggregate query. This grid column
appears only if you have chosen Group By from the toolbar or have added
a GROUP BY clause to the SQL pane. |
|
Criteria |
Specifies a search condition
(filter) for the associated data column. Enter an operator (the default
is "=") and the value to search for. Enclose text values in
single quotation marks.
If the associated data column
is part of a GROUP BY clause, the expression you enter is used for a HAVING
clause. |
|
Or... |
Specifies an additional
search condition expression for the data column, linked to previous expressions
with a logical OR. You can add more Or ... grid columns by pressing the
TAB key in the rightmost Or ... column. |
In the Grid pane you can specify:
• Columns
to display and column name aliases.
• The
table that a column belongs to.
• Expressions
for calculated columns.
• The
sort order for the query.
• Search
conditions.
• Grouping
criteria, including aggregate functions to use for summary reports.
Changes you make in the Grid pane are automatically reflected in the
Diagram pane and SQL
pane. Similarly, the Grid pane is updated automatically to reflect
changes made in the other panes.
Related Topics:
 How to create a view
About SQL Query Builder
About the SQL Query
Builder Layout
Diagram Pane
SQL Pane
Results Pane
| 
