Using SQL Query Components

Use the for each statement to execute and iterate over the result set of a cataloged SQL query.

Query components define one attribute for each column returned by the query.

Simple Queries

To execute the query, simply iterate over the component using the for each statement:

  for each record in TotalItemsQty do
    display record.qty
  end

Parametric queries

To execute a parametric query, you must provide the values for all its parameters to the constructor of the query component. The following example passes values for the "type" parameter defined by a query:

  for each record in TotalItemsQtybyType(type: "myType") do
    display record.qty
  end