Nested PHQL Query Conditions with Query Builder

Question

Nested PHQL Query Conditions with Query Builder

jasonmhead May '14

Created May '14	Last Reply May '14	Replies 1	Views 1513	Votes -1

jasonmhead 5.4k

May '14

Is there a way to nest/group conditions with the OO PHQL query builder?

Say in raw SQL you have SELECT id, name FROM table WHERE (id = 1 AND name = 2) OR (id = 1 AND name = 3)

With the query builder $queryObj->from('table') ->columns(array('id','name')) ->where('id = 1') ->andWhere('name = 2') ->orWhere(...) // nesting/grouping breaks down/un-expected nesting after this point

1

nazwa · Answer 1 · 2014-05-04T15:29:45-07:00

Try specifying more than one condition within a single where block:

$queryObj->from('table') 
   ->columns(array('id','name'))
   ->where('id = 1 AND xx = 2')
   ->orWhere('id = 2 AND xx = 1');