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.

Data Model Questions /

default_sort using secondary table


Reply


2 Posts   1204 Views

Avatar
Nicolaas

Forum Moderator, 213 Posts

7 February 2011 at 3:53pm

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

Avatar
swaiba

Forum Moderator, 1805 Posts

12 February 2011 at 1:01am

does this thread help? (towards the end some is doing similar i think, sort based on join)
http://silverstripe.org/general-questions/show/5768?start=0