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 transforming_a_result_to_dataobjectset
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 DataReport
and SQLReport
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.
cheers