Jump to:

5450 Posts in 1672 Topics by 1197 members

Customising the CMS

SilverStripe Forums » Customising the CMS » sort subpages case insensitive

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 338 Views
  • ivo
    Avatar
    Community Member
    19 Posts

    sort subpages case insensitive Link to this post

    Hi,
    could it be that the "sort sub-pages" option, that appears on right click on a parent-page, sorts case sensitive?

    I have pages with upper and lowercase initials and it sorts with uppercase first:
    like so:

    A page
    B page
    C page
    a page
    b page
    c page
    Ö page

    How can i make it sort case insensitive like:

    A page
    a page
    B page
    b page
    ...

    Any hint appreciated!

  • ivo
    Avatar
    Community Member
    19 Posts

    Re: sort subpages case insensitive Link to this post

    Seems to be a Mysql "feature", i guess it depends on the collation.

    In the frontend you could solve it via: order by UPPER(title)

    In the backend this might be an option: http://www.ssbits.com/tutorials/2011/custom-sorting-in-the-cms-sitetree/ combined with the UPPER command
    but i didnt tried that

    338 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.