Multi Item Region Sort Order not showing A-Z

SimonClay · Mar 31st 2021

In Perch Admin I have a multi item region, with Region options set to Sort by: Name and Sort order: Ascending (A-Z, oldest to newest).

But if the 'Name' starts with a lowercase letter it is displaying them last in the list.

Eg:

Alpha

Bravo

Delta

charlie

Is this a known bug. Does anyone else experience this?

Byron Fitzgerald · Apr 6th 2021

In a MySQL DB ordering is case sensitive and needs to be customised to allow for case insensitive ordering. In raw SQL you'd need to do something like

Code

Select col
from myTable
order by lower(col)

Though as perch adds quotes to the order column I'm not sure you'd be able to create a query in this manner

SimonClay · Apr 6th 2021

Thanks Byron, I didn't know that.

I will leave as is. It just doesn't make much sense to the end user. In this instance it is a list of Company names. Sometimes the names start with lower case, eg. eHealth.

On the front end, perch_content_custom sorts them as expected. It's just in the backend it looks a bit odd.

Thanks very much for the info.