doctrine findby relation
- by iggnition
I'm having trouble selecting a subset of data with doctrine.
I have 3 tables
Location
Contact
Contact_location
The contact and location tables hold a name and an id the other table holds only ID's. For instance:
Location
loc_id: 1
name: detroit
Contact
contact_id: 1
name: Mike
Contact_location
loc_id: 1
contact_id: 1
In doctrine there is a many to many relation between the location and contact tables with contact_location as the ref_class.
What i want to do is on my location page i want to find all contacts where for instance the loc_id = 1.
I tried:
$this->installedbases = Doctrine::getTable('contact')->findByloc_id(1);
hoping doctrine would see the relation and get it, but it does not.
How can i make doctrine search in relevant related tables? I read it can be done using Findby but i find the documentation unclear.
