New calculated attribute operator - ORDERBY (v.22)

In v.22 we are expanding the capabilities of the calculated attributes by introducing a new operator - ORDERBY:


 In general, the ORDERBY is used in combination with the TOP operator. Otherwise, the TOP clause will return the N number rows of the SELECT in an uncertain order. For this reason, it is the best practice to use the TOP clause with an ORDER BY to obtain the first N results sorted by something.

The results can be sorted in either ascending or descending according to the values of a particular attribute. The sorting is executed on the server, which makes it very fast and improves the performance, as its use avoids the local (client-side) sorting which requires downloading of larger sets of data.

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk