hi
I have a table called "options" and a table called "option groups". I want to sort the options by group and then by option. For the sorting, I have added the Sort field to both tables...
I would like to sort Options like this:
static $default_sort = "OptionGroup.Sort ASC, Option.Sort ASC";
I added the following function to Option:
<?php
class Option extends DataObject {
...
static $default_sort = "OptionGroup.Sort ASC, Option.Sort ASC";
public function extendedSQL($filter = "", $sort = "", $limit = "", $join = "", $having = ""){
$join .= " LEFT JOIN \"OptionGroup\" ON \"OptionGroup\".\"ID\" = \"Option\".\"OptionGroupID\"";
return parent::extendedSQL($filter, $sort, $limit, $join, $having);
}
...
}
However, it does not work...