> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Preference section Sorting

> Preference section Sorting

To view all preferences in this section, use the following SQL:

```SQL theme={null}
SELECT * FROM UserPreference WHERE prefsection='Sorting'
```

Sorting - controls how various lists of people are presented to the user.

| Preference        | Description                                                                                                   | Control type | Access                          |
| ----------------- | ------------------------------------------------------------------------------------------------------------- | ------------ | ------------------------------- |
| SortingAssociates | The display format and sort order of associates in lists (e.g. Last name, First name or First name Last name) | List         | Admin, Crm, Admin users, Wizard |
| SortingLists      | The display format and sort order of items in lists (e.g. name or rank)                                       | List         | Admin, Crm, Admin users, Wizard |
| SortingPersons    | The display format and sort order of contacts in lists (e.g. Last name, First name or First name Last name)   | List         | Admin, Crm, Admin users, Wizard |