3060 Posts in 864 Topics by 646 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1400 Views |
-
[Resolved] Alphabetizing/Sorting A Data List
25 January 2009 at 10:43am Last edited: 26 January 2009 1:00pm
Hello,
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,
Joe -
Re: [Resolved] Alphabetizing/Sorting A Data List
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"
-
Re: [Resolved] Alphabetizing/Sorting A Data List
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?
Thanks
-
Re: [Resolved] Alphabetizing/Sorting A Data List
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?
-
Re: [Resolved] Alphabetizing/Sorting A Data List
26 January 2009 at 12:54pm
You can use ASC/DESC to change the order.
-
Re: [Resolved] Alphabetizing/Sorting A Data List
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 -).
D'OH!!
| 1400 Views | ||
|
Page:
1
|
Go to Top |
