Running Subquery in doctrine is not giving correct Result

Question

sql

WHERE code= 'abc' AND (column_name NOT IN ('436') or column_name is null)

Doctrine code

            ->innerJoin('Bundle:Web', 'p', 'WITH', 'b.pid= p.id')
            ->where('a.code= :cust_id')
            ->andWhere('p.column_name  NOT IN ( :id)')
            ->setParameter('id', array_keys($id)[0])
            ->orWhere('p.column_name  is null')

Running Dql gives different Result in Symfony2.

any suggestion is most welcome.

Your first query is `X AND (Y OR Z)` but your second query appears to be `X AND Y OR Z` which is the same as `(X AND Y) OR (Z)`. This pattern appears to be common : https://stackoverflow.com/questions/6878448/doctrine-or-where — MatBailie, Apr 17 '18 at 10:00

score 1 · Answer 1 · answered Apr 17 '18 at 10:13

solution that i tried

        ->innerJoin('Bundle:Web', 'p', 'WITH', 'b.pid= p.id')
        ->where('a.code= :cust_id')
        ->andWhere('p.column_name  NOT IN ( :id) or p.column_name  is null ')
        ->setParameter('id', array_keys($id)[0])

here in above dql it saves orWhere condition in dql.

Running Subquery in doctrine is not giving correct Result

1 Answers1