Sort view

This view enables sorting the retrieved rows in a desired order.

Drag the desired fields above Drag fields above this line and click-set each line to ascending (arrow button up) or descending (arrow button down) order. To establish a hierarchical sort, drag all desired fields above Drag fields above this line and position them in the desired order.

The example below sorts the returned rows by Customer ID in ascending order (i.e. alphabetically), and for each found customer it sorts the rows further by Freight in descending order (the largest value first):