3070 Posts in 869 Topics by 651 members
|Go to End|
2 November 2009 at 12:49am
suppose I have:
static $summary_fields = array(
I want to order the search results, for one " order by Name DESC", where can I specify the order?
2 November 2009 at 9:59am
You can specify a $default_sort on your dataobject to set how it sorts itself.
// on your dataobject
static $default_sort = "Name DESC";
Note this is a global setting so any other <% controls %> or dataobject sets relating to that dataobject type will be sorted in that way.
18 March 2010 at 9:10am
How about ordering by a linked DataObject?
For example I have set $summary_fields to include "Sector.Name", referring to a has_one relationship with the Sector DataObject.
default_sort = "Sector.Name ASC" is throwing an error - as I'd expected. How could I fix this?
19 March 2010 at 4:06am
I've noticed the option to sort that field in the search results table isn't available.
I've tried adding it to "Sector.Name" to $search_fields but that's not doing anything.
Bit rusty on the SQL front, but I assume the query is selecting Sector.Name, otherwise it wouldn't be able to search or retrieve it, am I right? So am I just using the wrong $default_sort argument?
Thank you for your time!
|Go to Top|