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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Data Model Questions /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

[Resolved] Alphabetizing/Sorting A Data List


Go to End


6 Posts   3132 Views

Avatar
jfusco

Community Member, 53 Posts

25 January 2009 at 10:43am

Edited: 26/01/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

Avatar
ajshort

Community Member, 244 Posts

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"

Avatar
jfusco

Community Member, 53 Posts

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

Avatar
jfusco

Community Member, 53 Posts

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?

Avatar
ajshort

Community Member, 244 Posts

26 January 2009 at 12:54pm

You can use ASC/DESC to change the order.

Avatar
jfusco

Community Member, 53 Posts

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!!