Query builder symfony2 using where IN

Question

I have the following query builder to add to my entity.

'query_builder' => function(\Teln\OperatorBundle\Entity\SoftswitchRepository $er) use ($idBase) {
    $qb = $er->createQueryBuilder('t')
    ->where('t.base IN (:id)')
    ->setParameter('id', $idBase);

    return $qb;
},

and $idBase= $builder->getData()->getBases();

So $idBase is a collection.

How to add this to the where using IN ?

@venu this is not really a duplicate since the syntax is correct (and was the same from 2nd answer from your dup). Caryl just need to convert the collection to an array of ids. — j0k
– j0k, Commented Apr 2, 2013 at 7:59
hmm yes, apologies for misunderstanding it... +1 for the answer. — Venu
– Venu, Commented Apr 2, 2013 at 8:03

Erioch · Accepted Answer · 2013-04-02 07:32:32Z

3

Try to convert the parameter $idBase to a simple array with the id's or a string

answered Apr 2, 2013 at 7:32

Erioch

3594 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Query builder symfony2 using where IN

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related