Search results in a web page
can be grouped.
To group search results:
||From the catalog, open the page in which you want to group
||In the object tree, double-click the TableColumn object on
which you want to group first.
||In the Property Inspector, set the GroupBy property to:
||Set the OrderBy/GroupBy Position property to: 1.
||If you want to use a nested GROUP BY, repeat these steps for
the columns on which you want to group next, and set the
OrderBy/GroupBy Position property accordingly.
The result can be compared
with the SQL GROUP BY clause:
GROUP BY <column1>,
The Page Engine now adds a
GROUP BY clause to the SQL statement that is sent to the database.
Take care that the output columns must be compatible with the GROUP