Doctrine error when using SUM(a.id=1) as `ìdentifier`: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '='
I am trying to execute a query in doctrine that contains something like this
SUM(a.id = 1) as `1`
for some reasons it always gives me the following error:
[Syntax Error] line 0, col 15: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '='
This is the code i am using
$result = $em->getRepository('MyBundle:PlayerAction')
'SUM(a.id=1) as `1`,
SUM(a.id=2) as `2`,
SUM(a.id=3) as `3`,
->where('pa.timestamp > ?1')
->setParameter(1, time() - $time)