3237 Posts in 943 Topics by 684 members
|Go to End|
25 January 2009 at 10:43am Last edited: 26 January 2009 1:00pm
I have looked in the SS documentation and located the syntax for the DataObject::Get query:
$records = DataObject::get($obj, $filter, $sort, $join, $limit);
My question is, what are the valid arguments for $sort? If I want to alphabetize my query results, what value needs to be in that parameter?
Sorry if this is a noob question, my eyes are tired from looking at the web and my brain can't figure out how to phrase my searches anymore.
Thanks in advance,
25 January 2009 at 1:57pm
The $sort param is exactly the same as your SQL ORDER clause (without the actualy ORDER BY part). To sort alphabetically, you just do something like "`MyField` DESC"
25 January 2009 at 4:43pm
I'm hanging my head in embarrassed shame but I have very little idea what you just said. I'm not familiar with the SQL ORDER clause. Are you saying I need to put "DESC" in place of $Sort in the expression?
26 January 2009 at 12:49pm
Alright, I figured out I could put "Title DESC" into the $Sort parameter and it sorts... from Z to A. How do I reverse the sort?
26 January 2009 at 12:54pm
You can use ASC/DESC to change the order.
26 January 2009 at 1:00pm
Yep, just figured that out. Actually, I just removed the DESC qualifier (which I originally thought meant DESCription, not DESCending - FACEPALM -).
|Go to Top|