18590 Posts in 4875 Topics by 2285 members
General Questions
SilverStripe Forums » General Questions » Sort back-end (BlogEntry's)
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba
|
Page:
1
|
Go to End | |
| Author | Topic: | 703 Views |
-
Sort back-end (BlogEntry's)

9 February 2011 at 3:48am
How can i sort my blogentry's by date?
Tried things like this, but its not working for me:
SiteTree::$default_sort = 'IF("SiteTree"."ClassName" = \'BlogEntry\', LOWER("SiteTree"."DESC"), "SiteTree"."Sort")';
SiteTree::$default_sort = 'IF("SiteTree"."ClassName" = \'BlogEntry\', LOWER("SiteTree"."Created"), "SiteTree"."Sort")';
SiteTree::$default_sort = 'IF("SiteTree"."ClassName" = \'BlogEntry\', LOWER("SiteTree"."Created"), "SiteTree"."Created")';The search form didn't give me much help.
-
Re: Sort back-end (BlogEntry's)

28 May 2011 at 3:38am
Late answer, but maybe someone else needs this - I found this solution:
SiteTree::$default_sort = 'IF("SiteTree"."ClassName" = \'BlogEntry\', NOW() - "SiteTree"."Created", "SiteTree"."Sort")';
Cheers,
Andy
| 703 Views | ||
|
Page:
1
|
Go to Top |

