Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.
Sign up to join this community
I originally asked this on Stack Overflow, but I'm hoping for more response here.
In Craft, I'm trying to order entries by the title. Each title is a number, but the sort function handles it like a string. Because of that 100 shows up before 2, 31 before 4, and so on.
{% for entry in craft.entries.section('mySection').order('title').find() %}
<h2>§{{entry.title}}</h2>
{% endfor %}
Is there a way to do this without extending twig?
You can do that using MySQL’s cast() function:
craft.entries.section('mySection').order('cast(title as unsigned)')
Alternatively, you might get better performance if you create an actual Number field called “numberTitle”, attach it to your Entry Type, and set the Entry Type’s title to be dynamically generated using the template “{numberTitle}”. Then you can just order by that field instead:
craft.entries.section('mySection').order('numberTitle')
field_ in front of the field handle. Eg: craft.entries().section('mySection').orderBy('cast(field_customFieldHandle as unsigned)') (Also use orderBy instead of order in Craft 3)
– Brimby
Oct 28 '20 at 22:24
Twig doesn't have a natsort() filter.
But I've put together a simple plugin which extends the sort-filter:
