Doctrine where clause with an array

Question

I have an entity called "invoice" with many "subscription" such that "invoice" and "subscription" are in a many to many relationship.

class Invoice
{
/**
 * @ORM\Column(type="integer")
 */
protected $a;

/**
 * @ORM\Column(type="integer")
 */
protected $b;

/**
 * @ORM\ManyToMany(targetEntity="Subscription", inversedBy="invoices")
 */
protected $subscriptions;

public function __construct()
{
    $this->subscriptions = new ArrayCollection();
}

//typical setters and getters
}

Using the querybuilder, how do I get a set of matching entities using the where clause on subcription?

$subscription = ;//something pulled from the db and is a "subscription" object
$em->createQueryBuilder()
            ->select('p')
            ->from('Invoice', 'p')
            ->where('p.a = :a')
            ->andWhere('p.b = :b')
            ->andWhere('p.subscriptions has :subscription')   //this line here I need help
            ->setParameter('a', 1)
            ->setParameter('b', 2)
            ->setParameter('subscription', $subscription)
            ->getQuery()
            ->getResult();

Alexey B. · Accepted Answer · 2014-03-05 07:09:43Z

5

Doctrine have special statement MEMBER OF for this aim. Another solution is to make subquery.

->andWhere(':subscription MEMBER OF p.subscriptions')

Examples you can find in official doctrine documentation.

answered Mar 5, 2014 at 7:09

Alexey B.

12k2 gold badges51 silver badges76 bronze badges

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

Comments

Daniel · Accepted Answer · 2014-03-05 07:09:54Z

0

I'm not entirely sure, but perhaps you should join subscriptions.

$subscription = ;//something pulled from the db and is a "subscription" object
$em->createQueryBuilder()
        ->select('p')
        ->from('Invoice', 'p')
        ->join('p.subscriptions', 'subscription');
        ->where('p.a = :a')
        ->andWhere('p.b = :b')
        ->andWhere('subscription = :subscription')   //this line here I need help
        ->setParameter('a', 1)
        ->setParameter('b', 2)
        ->setParameter('subscription', $subscription)
        ->getQuery()
        ->getResult();

Alternatively, if subscription has an id, you can use that instead of the object.

answered Mar 5, 2014 at 7:09

Daniel

4,58717 silver badges34 bronze badges

Collectives™ on Stack Overflow

Doctrine where clause with an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related