Sorting and grouping

You can sort and group a view by column values. For example, the following view groups title records by author, and sorts each group alphabetically:

Sorting and Grouping Result

The Sorting and Grouping section of the Edit View page allows you to specify sorting and grouping:

Sorting and Grouping Section

This section has the following options:

  • Group By — Select a field from the first drop-down list if you want records grouped by that field. Select Ascending or Descending from the second drop-down list to specify the order in which grouped records will appear.
  • Sort By — Select a field in the first drop-down list to sort records by that field. Select Ascending or Descending from the second drop-down list to specify the direction in which records will appear.
  • ...then by — Select a column and direction to further sort records in the view.
  • Disable dynamic records sorting by clicking on the links atop of columns. — Select this check box to disable dynamic sorting in a view. See Column data options for more information.

In the following screen, the view groups Title records by Author; within each group, the records are sorted by Title and then by Status.

Sorting and Grouping in a View