In the graphical information object editor, perform the following tasks:
Choose maps and information objects.
Specify output columns.
Specify column categories.
Specify joins.
Specify filters.
Specify the GROUP BY clause.
Specify the HAVING clause.
Specify parameters.
Using the expression builder
Many of the steps to create an information object query involve specifying a column or an expression.
When designing a query, you can use Actuate SQL expressions to specify filters or joins, create aggregate data, and so on. For example, you can type expressions, such as officeID = 101 to specify that the data returned by the query must have 101 in the officeID column.
Expression Builder helps you create expressions by providing a graphical interface with selections for the available parts of an expression. In Expression Builder, you can build the expressions graphically by selecting constants, operators, functions, column names and so on from a list.
Figure 3‑3 shows Expression Builder. You can drag items from the left pane to the right pane or insert items by choosing the appropriate icon. If you select a function in the left pane, the function signature appears in the bottom pane.
Figure 3‑3 Using Expression Builder to create expressions
Choose maps and information objects.