How to change order of commands in doctrine Criteria

Vote count:

0

So this is how I use criteria:

$criteria = Criteria::create();
$criteria->andWhere($criteria->expr()->eq('author', /**/));
$criteria->orWhere($criteria->expr()->eq('author', /**/));
$criteria->orWhere($criteria->expr()->eq('author', /**/));

which results in this sql command:

WHERE 

      (
        (
          t0.author_id = ? 
          OR t0.author_id = ?
        ) 
        OR t0.author_id = ?
      ) 

What if I need this?

WHERE 

      (
        (
          t0.author_id = ? 
          OR t0.author_id = ?
          OR t0.author_id = ?
        )
      ) 

Is there any way how I can change the association of brackets?

asked 40 secs ago

Tomáš Pastorek

109

How to change order of commands in doctrine Criteria