Doctrine2 from subqueries

Question

I need to convert the following code to doctrine but cant seem to find the right Doctrine2 function.

Select 
ProductName,
WeekNumber,
sum(sale)
from
(
    SELECT 
    ProductName,
    DATEDIFF(week, '2011-05-30', date) AS WeekNumber,
    sale
    FROM table
)
GROUP BY
ProductName,
WeekNumber

Thank you

http://stackoverflow.com/questions/6637506/doing-a-where-in-subquery-in-doctrine-2 — calumbrodie, Mar 27 '13 at 05:50

Ocramius · Accepted Answer · 2013-04-02T07:53:52.507

1

Doctrine 2 ORM does not support subqueries in the FROM clause. The only allowed locations for a subquery are the WHERE and the HAVING clauses, which are supported by the various RDBMS vendors.

Please check the complete EBNF of DQL

edited Apr 02 '13 at 07:53

answered Mar 29 '13 at 12:18

Ocramius

24,722
7
100
106

Doctrine2 from subqueries

1 Answers1