Doctrine - How do you ask WHERE cond1 AND ( cond2 OR cond3)

Question

While using Doctrine in a Symfony project I've come into the situation where I need to apply a condition and then one of two following conditions (which both happen to be sub-queries). I know of the andWhere() and orWhere() functions, but am having trouble using these to generate things like: WHERE cond1 AND ( cond2 OR cond3)

http://stackoverflow.com/questions/1049617/complex-where-clauses-using-the-php-doctrine-orm allowed me to do what I wanted. — m14t, Nov 02 '09 at 05:18

score 2 · Answer 1 · answered Nov 10 '09 at 20:13

You can do this whith DQL:

$models = Doctrine::getTable('ModelName')
    ->findByDql(
        'field_one = ? AND (field_two = ? OR field_three = ?)',
        array('cond_1','cond_2', 'cond_3')
    );

So $models will be a Doctrine_Collection with all found elements.

score 0 · Answer 2 · answered Nov 02 '09 at 04:03

0

for the cond2 OR cond3 use wherein

where cond1 and wherein cond2 or wherein cond3

hopefully this gets you started

answered Nov 02 '09 at 04:03

theraven

4,825
3
20
20

This seems to help with the subquery part, but doesn't seem to aid in adding the hierarchy to my AND / OR opperators, right? – m14t Nov 02 '09 at 04:26

score 0 · Answer 3 · edited Jul 09 '10 at 19:34

0

I haven't heard of this tool but shouldn't something like

... where cond1 andWhere (cond2 orWhere cond3)

work? Or whatever the actual syntax is. Feel free to tell me if I'm wrong and I'll delete it and slunk off in a corner ;)

edited Jul 09 '10 at 19:34

Tom H

46,766
14
87
128

answered Nov 02 '09 at 05:57

RCIX

38,647
50
150
207

Doctrine - How do you ask WHERE cond1 AND ( cond2 OR cond3)

3 Answers3