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