Selecting Output Fields

  1. To add a field to the list of query output fields, do as follows:
    1. In the Query Building Canvas, check the box at the left of the field name in the datasource field list, or
    2. In Apply Operations, go to the Expression column and select a field name from the drop-down list.
  2. To include all the fields of the object, check the box at the left of the asterisk item in the datasource field list.
    Note:
    • If you do not select any fields from the query datasources, an asterisk item will be added to the SELECT list of the resulting query, for example, Select * From "…". This is because a SELECT query without any columns will produce an error for most database servers.
    • If you select any field or add any output expression to the query, the asterisk item is removed from the query.
  3. To remove an expression from the SELECT list of the query, clear the check box in the Output column.
  4. To set an alias for an expression, enter the alias in the Alias column. Aliases become the headings of columns in the resulting dataset.
  5. To set an aggregate function, select an aggregate from the drop-down list in the Aggregate column. An aggregate function runs the calculation on a set of values and returns a single value.