Doctrine: Select statement using equals not accepted

Question

According to DDC-2204 issue which states

[Order by With Equals] is supported by including the condition in the SELECT clause, aliasing it, then using it. You might need to use "AS HIDDEN name" to prevent it from appearing in the result

following DQL should be possible:

SELECT main.id = 1 AS test FROM Entity main ORDER BY test

However, when I try this (using 2.4), I get

Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got '='

It seems the developer-advised method of putting the condition into SELECT does not work. Is this a bug and / or is there another way of selecting and / or ordering by condition.

I found: http://stackoverflow.com/questions/15257538/how-to-order-by-a-computed-value-in-dql — Alexey Kosov, Apr 20 '15 at 12:22

score 4 · Accepted Answer · answered Aug 20 '15 at 08:57

4

It is possible to use case statement:

SELECT (CASE WHEN main.id = 1 THEN 1 ELSE 0 END) AS test FROM Entity main ORDER BY test

answered Aug 20 '15 at 08:57

Aurelijus Rozenas

2,176
2
28
40

score 0 · Answer 2 · answered Sep 10 '14 at 12:17

0

I'm not sure, if I understand that article correctly, but it seems to refer to using the condition in the order by clause:

SELECT main.id AS test FROM Entity main ORDER BY test = 1

answered Sep 10 '14 at 12:17

RoToRa

37,635
12
69
105

... which doesn't work in Doctrine and the proposed solution - putting it in SELECT clause - does not either, apparently. – Olia.Bn Sep 10 '14 at 13:52

Doctrine: Select statement using equals not accepted

2 Answers2