PHP | Problem - sorting is strange
public function TeamMembersSorted() {
return $this->TeamMembers()
->leftJoin("Team", "\"TeamPage_TeamMembers\".\"TeamID\" = \"Team\".\"ID\"")
->sort(array(
'Team.Priority' => 'DESC',
'Employeee.Surname' => 'ASC'
));
}
returns this error:
...
FROM "Employee"
INNER JOIN "TeamPage_TeamMembers" ON "TeamPage_TeamMembers"."EmployeeID" = "Employee"."ID"
LEFT JOIN "Team" ON "TeamPage_TeamMembers"."TeamID" = "Team"."ID"
WHERE ("TeamPage_TeamMembers"."TeamPageID" = '177')
ORDER BY "Employee"."Priority" DESC, "Employee"."Surname" ASC
LIMIT 15
Unknown column 'Employee.Priority' in 'field list'
11/02/2013 4:27pm
PHP | Solution - Anonymous
->sort(array("\"Team\".\"Priority\"" => 'DESC',
solved