Sorting in Grid and Parent Dropdown Lists

Settings for default sorting of data by the Entity List API.

Default Sorting

Entity Field properties define the default sort behavior. Two properties control how the system sorts data:

• List Display > Default Sort Index - The system applies sorts in sequence based on this index. The system applies the lowest index number first.

• List Display > Default Sort Direction - Ascending or Descending direction of the sort.

Entity Search UI - Sorting of Results

The default sort is applied on the Search UI when the user-defined sort has not been specified, that is, the user has not clicked on a column header to sort the data.

Entity Details UI - Sorting of Options in a Parent Dropdown

The default sort is always applied to options in a Parent(1) Field's dropdown on the Details UI. If this sort needs to be customized then From List validation can be used along with an Options Loader API/Script. See the From List section in Entity Field Validations.