How to Group Search Results

Previous Next

See Also

Search results in a web page can be grouped.

To group search results:

1. From the catalog, open the page in which you want to group search results.
2. In the object tree, double-click the TableColumn object on which you want to group first.
3. In the Property Inspector, set the GroupBy property to: Yes.
4. Set the OrderBy/GroupBy Position property to: 1.
5. 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>, <column2>

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 BY columns.