Doctrine query builder - nested queries, AS keyword, select functions

Question

SELECT t1.field1 AS foo, (SELECT ABS(SUM(amount)) FROM table2 t2) FROM table1;

How can I convert this query into symfony 2 doctrine query builder?

$results = $this->getEntityManager()->createQueryBuilder()
           ->select(...)
           //...

vobence · Accepted Answer · 2014-07-15 17:57:10Z

3

$results = $this->getEntityManager()->createQueryBuilder()
  ->select('t1.field1')
  ->addSelect('abs(sum(amount)) t2')
  ->from('BundleName:Entity', 't1)
  ->leftJoin('t1.field', 'another')
  ->getQuery()->getResult();

Maybe this works, I found a similar problem and a solution here: Select Subquery with COUNT() in Doctrine DQL

Or if it not works, you can create two queries for the problem, and you use the first query's result in the second query.

answered Jul 15, 2014 at 17:57

vobence

5232 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Doctrine query builder - nested queries, AS keyword, select functions

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