Multi Item Region Sort Order not showing A-Z

  • 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
    1. Select col
    2. from myTable
    3. 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

  • 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.