Define Default Sort Column

With the new SortOptions element for query view specs, you can now define default sort columns for list builders.

This new element allows you to display the rows of a list in a particular order when users first access the list builder. The rows are sorted based on the default column that you specify, and you can also select whether to display rows in ascending or descending order.

To define a default sort column on a list builder's query view spec, you insert the SortOptions element within the ListBuilder element and then specify the name of the default sort column in the DefaultSortColumn attribute. You can also indicate whether to sort in ascending or descending order in the optional DefaultSortDirection attribute.

<SortOptions DefaultSortColumn="INSERT_COLUMN_NAME" DefaultSortDirection="Descending" />

After you load the query view spec and users access the list builder, the display order for the rows are based on the values you supply in the SortOptions element.

Tip: For more information about the SortOptions element, see SortOptions Element.