Are there any tutorials out there on how to write a custom SQL query with COUNT() and GROUP BY,
maybe put them in a DataObjectSet,
then feed them into TableListField?
this kind of does it [url http=http://doc.silverstripe.org/doku.php?id=sqlquery#transforming_a_result_to_dataobjectset]transforming_a_result_to_dataobjectset[/url]
but it looks like I need to make a custom DataObject for the singleton?
$myDataObjectSet = singleton('Player')->buildDataObjectSet($result);
Is this "the way" to do it?
Is TableListField the only/best way to show Report results?
I see there's lots of 'Report' objects in the api documentation like [url http=http://api.silverstripe.org/default/DataReport.html]DataReport[/url]
and [url http=http://api.silverstripe.org/default/SQLReport.html]SQLReport[/url]
but the documentation is set to ToDo (or is it the functionality?) and those files aren't
Located in /sapphire/forms/DataReport.php (line 6)
Located in /sapphire/forms/SQLReport.php (line 3)
I see in 2.4.0 the Report section has been updated so this could all end up deprecated.