Skip to main content
This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.
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,
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"
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?
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?
You can use ASC/DESC to change the order.
Yep, just figured that out. Actually, I just removed the DESC qualifier (which I originally thought meant DESCription, not DESCending - FACEPALM -).