getresources sortdir natural order

169 Posts

spica8 Reply #1, 14 years, 2 months ago

I have a problem with mixed cases in titles. getresources sorts uppercases first and then lowercases: A,B,X,a,b,x. I would like A,a,B,b,X,x. How to achive that?

MODX Staff
10,725 Posts

opengeek Reply #2, 14 years, 2 months ago

You could try sorting it by using the MySQL LOWER() function like this:

[[getResources? ... &sortby=`LOWER(pagetitle)`

Though I'm not sure that is exactly what you want...

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

169 Posts

spica8 Reply #3, 14 years, 2 months ago

Does exactly what I need. Thanks a lot.