Add an Order By Query

Using Order By Query, you can build a query to sort the list items based on the given condition (similar to Order by clause of the sql queries). Data can be either in ascending or descending order.

To build an Order Byquery

1. In the Enterprise Console, click the Menu button, click Settings, and then click Lookup Settings. The Lookup Settings page appears.

2. Click the New Lookup List icon on the Ribbon Bar. The New Repository List Lookup dialog box appears.

3. Click the Query icon against Order By Query to build a query to sort the list items.

   The Dynamic Order By Query Builder dialog box opens.

   Field	Description
   Table	Click this text box to select the required table. The tables that are associated to a List are displayed in a tree menu. The tree menu displays the hierarchy of tables.
   Column	Select the column associated to the selected table.
   Sort	Select ASC to list the items in ascending order or DESC to list in the descending order.

4. Click Add to add the query.

   Multiple columns can be specified for the Order By query.

5. Click Save to save the query.

6. Click Clear to remove the data entered in the Query Builder.