Multiple WHERE using QueryBuilder

Question

When using the following only the last where is added to my query;

$qb = $this->getEntityManager()->createQueryBuilder();

$qb->select(array('qi'))
    ->from('Table:Qi', 'qi')
    ->where("qi.content = " . $content->getId())
    ->where("qi.queue = " . $child->getQueue()->getId());

I had to do this to make it take notice of both

$qb->select(array('qi'))
    ->from('Table:Qi', 'qi')
    ->where("qi.content = " . $content->getId() . 
                 " AND qi.queue = " . $child->getQueue()->getId());

This does not seem right? How can I use the first approach with multiple where calls?

Juan Sosa · Accepted Answer · 2013-03-08 18:35:01Z

31

You can use ->andWhere like this:

->where("qi.content = " . $content->getId())
->andWhere("qi.queue = " . $child->getQueue()->getId());

answered Mar 8, 2013 at 18:35

Juan Sosa

5,2801 gold badge37 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xDaizu Over a year ago

you actually dont need to use ->where before andWhere. You can alway use ->andWhere();

Collectives™ on Stack Overflow

Multiple WHERE using QueryBuilder

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related