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
Currently I am sorting the entries by an ID:
{% for gallery in craft.entries.section('Gallery').order('available desc').limit(none) %}
but I would like to show the latest entries on top, currently it shows available first but latest entries ones go to the bottom. How can I mix the above code with something like this?
.order('postDate desc') %}
If you want to order by multiple columns that include custom fields, first make sure you're at least on Craft 2.4.2684, then you'll be able to use this syntax:
{% for gallery in craft.entries.section('Gallery').order('postDate desc, available desc').limit(null) %}
Also note that that you should be using limit(null) instead of limit(none) if you want to result all results.
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'available' in 'order clause', but wen reversing the order it worked as expected :) .order('available desc, postDate desc')
Mar 19, 2015 at 18:12
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'available' in 'order clause'
Mar 19, 2015 at 18:20
available handle in the field layout of your Gallery section?
.order('this asc').order('that desc').limit(10). Just a hunch, but I can't test it out right now.