Yes, we can use containable to get the task's users. But if there is a user , I want to find all the tasks he owns. How can I do?
User table: id | name Task table: id | user_id | name We can't count on containable to help us to find the relate tasks. And I count on 'join' to help me to do this. Any suggestions? On Wed, Apr 1, 2009 at 2:09 AM, Amit <[email protected]> wrote: > > I highly recommend checking out the Containable behavior: > > http://book.cakephp.org/view/474/Containable > > It will simplify this code and let you easily add fields. > > On Mar 31, 8:28 am, joshua <[email protected]> wrote: > > For example: > > One task has many users. > > ######################## > > $condition = array(); > > $condition['joins'] = array( > > array( > > 'table' => 'users', > > 'alias' => 'User', > > 'type' => 'inner', > > 'foreignKey' => 'user_id', > > 'conditions'=> array('User.id = > > Task.user_id','User.deleted=0') > > )); > > ######################## > > I just want to find the user name , not all the fields in User table. I > try > > to add the 'fields' property in this array, but it seems not. > > -- > > Thanks > > Joshua > > > -- Thanks Joshua --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
