How to sort in DB Multi record loader

tempus 24 Jun, 2013
Hi!

How to sort records onload?
In DB Multi record loader event I see parameter field, but what command I have to write here?
I tried SQL and PHP commands, but failed.

Field name cf_id
Sort - DESC

Thanks
GreyHead 24 Jun, 2013
Hi tempus,

You can add an ORDER BY clause to the WHERE box, if you don't already have any content in there you need to add a valid WHERE clause too e.g. 1 ORDER BY `cf_id` DESC ( the 1 at the beginning completes the WHERE clause and 'WHERE 1' is always true so has no real effect.

Bob
tempus 28 Jun, 2013
Thanks Bob! It works perfectly.
This topic is locked and no more replies can be posted.