You can not search on conditions of a related model (generally, some
tricking with bind() might do the trick).
But, you can search for a group ($this->MyGroup->find()), which will
automatically get you all the related Users as well. You can further
filter these users with the Containable behaviour.
On 21 Sep 2008, at 07:44, Mojo wrote:
>
> Hi,
> I have 2 classes MyUser and MyGroup.
> Both of them are tied by HABTM relationship.
>
> I want to make a find all query that will find all Users belonging to
> a certain group I don't know how to make this query. All I got are
> examples with queries on the same table.
>
> class MyUser extends AppModel {
> var $name = 'MyUser';
> var $hasAndBelongsToMany = array('MyGroup');
> }
>
> class MyGroup extends AppModel {
> var $name = 'MyGroup';
> var $hasAndBelongsToMany = array('MyUser');
> }
>
> MyGroup has a field called 'name' and I'd like to make a query about
> that.
> Something like :
>
> SELECT *.u, *.g from MyUsers u, MyGroups g, MyGroup_MyUser m WHERE
> g.name = 'TheNameImLookingFor' and g.id = m.MyGroup_id and m.MyUser_id
> = u.id
>
> I tried :
>
> $this->MyUser->recursive = 2;
>
> $this->MyUser->find('all', array('conditions' =>
> array( 'MyUser.MyGroup.name' =>
> 'TheNameImLookingFor'
> )));
>
> How can I do it better ?
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
