Common use of Order By Clause in Contracts

Order By. Order By keys control the sorting of the data objects returned by the query. NOTE: Sorting is applied before Filter Results Based on Top N is applied. query's sort order. If you are sorting on a metric property, such as cpuUsage under Hosts, the algorithm automatically sorts on the metric's current/value property.

Order By. Order By keys control the sorting of the data objects returned by the query. NOTE: Sorting is applied before Filter Results Based on Top N is applied. NOTE: Row-oriented tables also have their own sorting capabilities. If used, these settings override the query's sort order. If you are sorting on a metric property, such as cpuUsage under Hosts, the algorithm automatically sorts on the metric's current/value property.