Query and subquery in symfony

Question

I use query and subquery in symfony query builder, but when execute it, it returns an error.

My code is :

 $subQb = $em->createQueryBuilder();

            $subquery = $subQb->select('COUNT(v.id)')
                ->from('AdminBundle:Visitsite', 'v')
                ->where('v.site = s.id')
                ->Andwhere('v.createdate > :date')
                ->setParameter('date', $date->format('Y-m-d'))
                ->getDQL();

            $subQb2 = $em->createQueryBuilder();
            $subquery2 = $subQb2->select('quantity')
                ->from('AdminBundle:Limitviewday', 'l')
                ->where($subQb2->expr()->eq('s.limitviewday', 'l.id'))
                ->getDQL();

            $qb = $em->createQueryBuilder();
            $query = $qb->select('s')
                ->from('AdminBundle:Sites', 's')
                ->where('s.quantity > 1')
                ->Andwhere('s.status = 1')
                ->Andwhere($qb->expr()->lte("($subquery)", "($subquery2)"));

            $settlements = $query->getQuery()->getResult();

And my result is

[Semantical Error] line 0, col 183 near 'quantity FROM': Error: 'quantity' is not defined.

Please help me.

yceruto · Accepted Answer · 2016-10-28 18:38:14Z

1

I think that error come from:

$subquery2 = $subQb2->select('quantity') // Expected '<alias>' or '<alias>.<property>'

instead:

$subquery2 = $subQb2->select('l.quantity')

answered Oct 28, 2016 at 18:38

yceruto

9,6155 gold badges42 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Query and subquery in symfony

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related