When I set the $summary_fields in a dataobject and use the .Nice syntax I will lose the ability to sort on this column, for example:
public static $summary_fields = array(
'Date1' => 'Date 1',
'Date2.Nice' => 'Date 2',
'Date3.NiceUS' => 'Date 2',
'boolean1' => 'Boolean 1',
'boolean1.nice' => 'Boolean 2'
);
In the example above I can sort the gidfield by “date 1”, but I cannot sort by “Date 2” or “Date 3”, the same for Booleans I can sort by “Boolean 1” but not by “Boolean 2”
Is this normal? And if so is there a workaround to get the sorting to work with better looking dates?