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.

Data Model Questions

[Resolved] Alphabetizing/Sorting A Data List


Reply

6 Posts   1674 Views

Avatar
jfusco

25 January 2009 at 10:43am (Last edited: 26 January 2009 1:00pm), Community Member, 52 Posts

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

Avatar
ajshort

25 January 2009 at 1:57pm Community Member, 244 Posts

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"

Avatar
jfusco

25 January 2009 at 4:43pm Community Member, 52 Posts

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

Avatar
jfusco

26 January 2009 at 12:49pm Community Member, 52 Posts

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?

Avatar
ajshort

26 January 2009 at 12:54pm Community Member, 244 Posts

You can use ASC/DESC to change the order.

Avatar
jfusco

26 January 2009 at 1:00pm Community Member, 52 Posts

Yep, just figured that out. Actually, I just removed the DESC qualifier (which I originally thought meant DESCription, not DESCending - FACEPALM -).

D'OH!!