Reorder records

Hi soj,

You can specify the sort order in the "Order By" field in the section editor or in the list viewer.

So, say you had a stafflist with a field called fullname, you could sort by the name (in ascending order) with this option:

$options['orderBy'] = "fullname";

Because this is just a regular MySQL "Order By" clause, you can use standard MySQL. So to sort in descending order you just add "DESC" after the fieldname like this:

$options['orderBy'] = "fullname DESC";

Would that work for you? Let me know if it will or if there was something else you were trying to do.

Wow, I missed that option in the editor.

I'd like to order by 'record number' ascending, but it's not taking.

soj

Update - I found what I was doing wrong - I confused field name with field label. Thanks!