list of users by field - two entries not displaying in order

Hi,
We are using the list feature of community builder to create a sorted list of users based on the custom field cb_firstaidexpirydate and the field last_name
The list is working nicely - displaying all the users in order - except two users that appear out of order at the top of the list.
Can you help with this?

Do those two users have a value for cb_firstaidexpirydate and a last name? Having empty fields could explain why they're at the top and you may want to consider using a filter to filter out users that don't have a value otherwise you can use Advanced Sorting to provide your own database query ORDER BY statement.

Hi Kyle,
That is the strange thing - those two users have valid values for both last name and cb_firstaidexpirydate.

There's no processing behind sorting. It's purely just sorting directly in the database query. So something about those fields values is resulting in the sorting you're seeing. For example if I have the below.

Name Ascending
Username Descending

This would give the following in the database query.

ORDER BY u.`name` ASC, u.`username` DESC

Using Advanced mode allows you to directly add all the contents after the "ORDER BY" allowing for more custom sorting behavior.