How to do SELECT COUNT(DISTINCT(field1, field2)) in Doctrine2 DQL?

Question

symfony

In a native PostgreSQL query, you can easily do

SELECT COUNT(DISTINCT(t.field1, t.field2)) FROM table t;

In DQL, with the same construction, an exception is thrown:

QueryException: [Syntax Error] line 0, col 22: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'o'

Can this be done in DQL?

Answer 1

First, the parentheses are not needed for the DISTINCT expression.
Secondly, DISTINCT in Doctrine does not support multiple arguments
. Thirdly, there is a hack to solve the previous two:

SELECT COUNT(DISTINCT CONCAT(t.field1, t.field2)) FROM table t;