I am trying to query for users that are assigned to a certain project in CakePHP. How could I basically achieve this:
$projectId = //Project ID query result.
$users = $this->Tickets->Users
->find('list', ['limit' => 200])
return $q->where(['ProjectsUsers.project_id' => $projectId]);
This code works when not using variables (eg. replacing $projectId with 8) but when I try to use variables I get:
Undefined variable: projectId
How can I pass variables into innerJoinWith?