We have this in our code:
$items = $items->sort(array('LastActivity' => 'DESC', 'ActivityDate' => 'DESC', 'Date' => 'DESC', 'Created' => 'DESC'));
But the generated sql seems to always just put Activity Date first:
...
ORDER BY "ActivityDate" DESC, "LibraryItem"."LastActivity" DESC, "LibraryItem"."Date" DESC, "LibraryItem"."Created" DESC
How do we specify a column list in the sort() such that it respects the order that they are specified in?