SmartConnect 2018

Query Builder Grouping and Sorting

To enable sorting of output query fields the Sort Type and Sort Order columns of the Query Columns area should be used.

The sort type column allows selection of the way columns will be sorted (ascending, descending)
The sort order column allows the order in which fields will be sorted to be defined.
To disable sorting by a specific field, clear the sort type column for that field.



To define grouping by some of the fields, and / or to define aggregate functions on the grouped rows the Group By checkbox column in the Query Columns area should be used.

When defining groupings and using criteria the query must define if the given criteria is for the group or for elements contained within the group.
By selecting an aggregate function (count, sum etc) an aggregate expression will be created for the value indicated in the Expression column.