I have an app with data where each record is a person. I want to sort alphabetically on first name... sounds easy. You click the column header for "first name" and it appears to sort from A-Z. However, it goes from A-Z and then randomly half-way through my records it starts from A again and goes A-Z.
After much investigation it appears all records created in 2018 sorted A-Z, and then separately all 2017 records sorted A-Z independently. This makes it very hard to actually find a record based on first name.
How can this unwanted extra sort criteria be removed?
Please sign in to leave a comment.