11/02/2013 4:23pm

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'


1 Comments 1 Solutions

11/02/2013 4:27pm

PHP | Solution - Anonymous

solved

->sort(array("\"Team\".\"Priority\""     => 'DESC',

Post Comment