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: DSP® and SQL Server no longer support the sort in a view in SQL.
Refer to Add List Boxes and Combo Boxes for general information.
To order the list box options:
-
Access the Page Columns page Vertical View for a list box or combo box.
-
Click Edit.
-
Click the Advanced Properties tab.
-
Enter the column that should sort n List Order By field.
-
Click Save.
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.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.