Ordering Lists

The list view of items allows for basic ordering by column.

  1. Click in the column header of a list. String columns are sorted alphabetically and numeric columns are sorted numerically.
  2. Click the column header name or up/down arrow to change the direction or the sort order of the column.

The ordering of a column is shown by the up/down arrow.

Note

  • When sorting, instances with no value for the sort field will sort to the top or bottom of the list, depending on the alphabetical sort direction: ascending or descending.
  • Capital letters will sort before lower case letters.
  • With no filter applied, sort will work on any column in the list view.
  • With a filter applied to a single column, sort will work on the filtered column only.
  • With a filter applied to more than one column, the sort functionality will not work.
  • Leading spaces on a field in the list view are dropped when rendering the list view, so this may affect the sort order.
  • The sort order of the Located At column will be according to the displayed string value and not the hierarchy path.