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
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
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
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
This topic is locked and no more replies can be posted.
