I'd like to know how I can sort a DataObjectSet that I've filled with ArrayData. I know I can sort it using the sort() method but I've tried different ways and never got a result.

On my Page_Controller I have roughly this function:

function()
{
$provinces = DataObject::get('Province'
$doSet = new DataObjectSet();
         
foreach($provinces as $province)
{
   $amount = $province->Tips()->Count();
   $provinceTitle = $province->Title;
$provinceID = $province->ID;
   $record = array('ProvId' => $provinceID, 'ProvTitle' => $provinceTitle, 'ProvTotal'=> $amount);
   $Ad = new ArrayData($record);
   $doSet->push($Ad)
}

return $doSet;
}

The reason it's on Page_Controller is that I want to call it on different types of pages...

I tried using
$provinces->groupBy(Title) as $province
too but that gave an error.

I would like to sort the data by ProvTitle, any hints on how to obtain this?
I was thinking of

$newSet = $doSet->sort(?????????)

But I'm not sure of how to write the argument to pass..

your answer is basically: custom getters and better usage of templates.

is there any reason for aliasing $province->ID to ProvId? you can use the original $provinces DataObjectSet in a template like this (with a function Provinces() on your Page_Controller)

[html]
<% control Provinces %>
$Tips.Count
$ID
$Title
$FilteredTips.Count
<% end_control %>
[/html]

now, if you want to count e.g. all tips with "Viewers=Anyone"-filtering, and Province has_many Tips, you would just write a custom getter FilteredTips() on Province.

Obviously the getComponents approach is not working for many_many relations, any clues on this?

Thanks for your help already!

DataObject::get works as well, but you have to specificy the id (or even manually join tables), which you don't have with the component-getters. the resulting object from component-getters is also a "special" DataObjectSet-subclass containing additional information on the queried relation (ComponentSet).