Nested select query in doctrine query builder

symfony doctrine-orm doctrine dql doctrine-query
quosal picture quosal · Dec 28, 2015 · Viewed 7.8k times · Source

In a Symfony2 project:

select * from
(
    select
        p.name as product, u.id, u.name
    from user u
    left join product_purchase pp on pp.user_id = u.id
    left join product p on pp.product_id = pp.product_id
    where p.type = 'something'
    order by p.id desc
) as up
group by up.id;

This is simplified query I want build with Doctrine Query Builder but couldn't find a solution yet. The important thing is ordering on join before grouping the result. Any help would be much appreciated.

Answer

darkomen picture darkomen · Dec 29, 2015

this is a example may help you because vote and check good response. He use a second queryBuilder var in a first qb with $qb->expr()->in( : subquery in queryBuilder Doctrine

Related questions

How to do a LIKE database query in Symfony2

This should be simple but I can't find a working example. Here's a controller method that throws the error "Invalid parameter number: number of bound variables does not match number of tokens". I'm posting the "searchterm" variable successfully but can't …

Read More
Symfony and Doctrine DQL query builder: how to use multiple setParameters inside if condition checks?

Using Symfony and Doctrine with the DQL query builder, I need to optionally add some WHERE conditions with parameters, with some if condition checks. Pseudo code example: $qb = $this->getEntityManager()->createQueryBuilder(); $qb = $qb ->select('SOMETHING') …

Read More
Combine IS NULL and :value in Doctrine 2 DQL

Since other (old) questions didn't get proper answers, I'll try it again: I regularly come across a scenario, where I want to query an entity with a specific value: $query = $em->createQuery('SELECT e FROM Entity e WHERE e.…

Read More