suppose I have:

static $summary_fields = array(
'Name',
'ProductCode'
);

I want to order the search results, for one " order by Name DESC", where can I specify the order?

Thanks,
Jin

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.

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?

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!