--- title: "Set the List Order By" slug: "set-the-list-order-by" updated: 2024-03-29T13:11:33Z published: 2024-03-29T13:11:33Z canonical: "skthelp.syniti.com/set-the-list-order-by" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Set the List Order By By default, like pages, list boxes are sorted based on the primary key. Use List Order By to sort select options in a list box based on another field. > [!NOTE] > Note > > Syniti Construct and SQL Server no longer support the sort in a view in SQL. Refer to [Add List Boxes and Combo Boxes](/v1/docs/add-list-boxes-and-combo-boxes) for general information. To order the list box options: 1. [Access the Page Columns page](/v1/docs/access-the-column-properties-page) *Vertical* View for a list box or combo box. 2. Click **Edit**. [*View the field descriptions for the Page Columns page*](/v1/docs/page-columns-h) 3. Click the **Advanced Properties** tab. 4. Enter the column that should sort n **List Order By** field. 5. Click **Save**. > [!NOTE] > Note > > When a field name is entered in **ListOrder By** field, the default order is ascending. To sort in descending order, enter the field name followed by a space and **desc**, for example, **ProductName desc**. Separate entries by a comma.