Configuration Guide

10.4

Back Next

Refining a Generic Query

After you create a generic query, you can refine the query by using the building blocks. Edit the query to open the building blocks. Each building block is contained on a tab in the properties pane.

The following table lists the tabs, describes the building blocks, and identifies the equivalent SQL syntax:

Tab Name	Building Block Description	SQL Syntax
Tables	Tables associated with this query.	FROM clause
Select	Columns associated with this query. You can add functions and constants to the columns.	SELECT `<list of columns>`
Conditions	Conditions associated with this query. Determines selection criteria for individual records.	WHERE clause
Sort	Sort order for the results of this query.	ORDER BY clause
Grouping	Grouping for the results of this query.	GROUP BY clause
SQL	Displays the SQL statement that is generated from the selected building blocks.	SELECT statement with all clauses