The Query Wizard ORDER BY Step

On the ORDER BY step of the Query Wizard you can select the order in which records are sorted when retrieved. Note, that if you also specified the TOP property, the data source will contain only first TOP records according to the sort order.  You can arrange these values differently when shown in a chart.  For example, you can retrieve the Top 5 records, specifying ORDER BY “UnitPriceSum Ascending” (fetching the 5 recorrds with the smallest values) and then show these 5 resords smallest first or largest first. In order to use a Geo-Proximity sort field please add a Geo-Proximity Where Clause first.

See Also

Query Wizard

The Query Wizard JOIN Step

The Query Wizard SELECT Step

The Query Wizard TOP Step

The Query Wizard WHERE Step

The Query Wizard ORDER BY Step

The Query Wizard FINISH Step