Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can use the order by clause to sort the results of a query by one or more fields in ascending or descending order.
Note
The sorting preferences of the SQL server on the data tier determine the default sort order. However, you can use the asc or desc parameter to choose an explicit sort order.
The example sorts work items first by Priority in ascending order, and then by Created Date in descending order.
Example
SELECT [System.Title] FROM workitems WHERE [System.State] = ‘Active' and [System.AssignedTo] = ‘joselugo' order by [Microsoft.VSTS.Common.Priority] asc, [System.CreatedDate] desc