Find model based on value of foreign key (one-to-one, and/or one-to-many

Question

Find model based on value of foreign key (one-to-one, and/or one-to-many

Trenton Craig Nov '13

Created Nov '13	Last Reply Nov '13	Replies 1	Views 648	Votes 0

Trenton Craig 5.8k

Nov '13

I can't find out through the documentation, but is there a way using Model::find(); to supply the value of a foreign key versus having to filter on the field itself?

IE, I have a table Job, that has a field: status_id, which is a relationship to the Status model. I want to be able to find all Jobs whose status is 'In Progress' (the status table is simply id, name).

Nikolay Kirsh · Answer 1 · 2013-11-22T02:21:07-07:00

$users = Users::findFirst( 123 );
$jobs = $users->getJobs( ['conditions'=>'status_id=?0','bind'=>[''in_progress']]  );