Hi there,
I tried the following with 3.1.12 to set the default sort of the dataobject Feature:
<?php
class FeatureGroup extends DataObject {
private static $db = array(
'Name' => 'VarChar',
'Sort' => 'Int',
);
class Feature extends DataObject {
private static $db = array(
'Name' => 'VarChar',
'TopName' => 'VarChar',
'Sort' => 'Int',
'ShowInComparison' => 'Boolean',
'ShowInList' => 'Boolean'
);
private static $has_one = array(
'FeatureGroup' => 'FeatureGroup',
);
private static $default_sort = "FeatureGroup.Sort, Sort";
and got this error:
[User Error] Couldn't run query: SELECT DISTINCT "InsurancePage_Features"."Text", "Feature"."ClassName", "Feature"."Created", "Feature"."LastEdited", "Feature"."Name", "Feature"."TopName", "Feature"."Sort", "Feature"."ShowInComparison", "Feature"."ShowInList", "Feature"."FeatureGroupID", "Feature"."ID", CASE WHEN "Feature"."ClassName" IS NOT NULL THEN "Feature"."ClassName" ELSE 'Feature' END AS "RecordClassName", "FeatureGroup"."Sort" AS "_SortColumn0" FROM "Feature" INNER JOIN "InsurancePage_Features" ON "InsurancePage_Features"."FeatureID" = "Feature"."ID" WHERE ("InsurancePage_Features"."InsurancePageID" = '16') ORDER BY "_SortColumn0" ASC, "Feature"."Sort" ASC Unknown column 'FeatureGroup.Sort' in 'field list'
The FeatureGroup table doesn't seem to be joined.
I found [https://github.com/silverstripe/silverstripe-framework/pull/3019]https://github.com/silverstripe/silverstripe-framework/pull/3019/, so this seems to have been fixed. Why do I still get the error?
Thanks in advance