Apply where condition on 2nd level association in CakePHP 2.5.x

Question

I want to add a where clause for my 2nd level association in cakephp. In my understanding this should work but it gives me an error

Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'User.email_address' in 'where clause'.

$options = array(
    'contain' => array(
        'People',
        'People' => array('User')
    ),
    'conditions'=> array(
        'User.email_address' => 'sample@mail.com'
    ), 
    'recursive' =>1,
);
$query = $this->Organization->find('all', $options);

Salines · Accepted Answer · 2016-09-05T14:35:21.707

2

$options = array(
    'contain' => array(
        'People' => array(
            'User' => array(
                'conditions'=> array(
                    'User.email_address' => 'sample@mail.com'
                ),
            ),
        ),
    ),
    //'recursive' =>1,
);
$query = $this->Organization->find('all', $options);

Read more:

http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html#containing-deeper-associations

edited Sep 05 '16 at 14:35

answered Sep 05 '16 at 14:29

Salines

5,674
3
25
50

it is working but it gives me the result with left join, like it gives me the results with User null where user not match. – iibtisam Sep 06 '16 at 06:21

Apply where condition on 2nd level association in CakePHP 2.5.x

Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'User.email_address' in 'where clause'.

1 Answers1