GROUP BY does not work with functions

This is documented in the EBNF of DQL that this not works.

Marked as improvement.

Is there any workaround?

Using a native query is a workaround.

There is another workaround that should work:

SELECT ...,   CAST(t.scheduledDate as date) AS castedDate
FROM Task t
...
WHERE
  ...
GROUP BY
castedDate

I tried this:

SELECT ... ,MONTH(t.fechaCreacion) as mes 
FROM Tramite t 
...
WHERE 
... 
GROUP BY 
mes 

But I get this error:

Message: [Semantical Error] line 0, col 202 near 'mes ': Error: 'mes' does not point to a Class.

Then only native query is a workaround for now

We work on this for 2.2

Ok I'll need to move my code to native query... Hope you can fix this with 2.2 or earlier ... Thanks

BTW I have put in a fix and so far have had no issues.... but this should be considered hack as I'm not very familiar with the internal workings of Doctrine.

See doctrine-dev groups:
https://groups.google.com/d/topic/doctrine-dev/QZMMnYV4V_8/discussion

HTH

Alex

Since this commit: https://github.com/doctrine/doctrine2/commit/2642daa43851878688d01625f272ff5874cac7b2
This issue is solved through the SelectExpression + Hidden + ResultVariable refer.

SELECT 
    ..., CAST(t.scheduledDate as date) AS HIDDEN groupDate
FROM Task t
    ...
WHERE
    ...
GROUP BY
    groupDate