I would like to know if it's possible to do a custom orderBy with
Doctrine? In other words, is there any Doctrine equivalent to this
SQL:
SELECT * FROM `table` ORDER BY FIELD(id,2,5,3,6,4,1);
I know I can do a normal Doctrine_Query and traverse the results array
and do manual sorting (which is my current alternative), however it
would be good if I can just grab the custom sorted data straight from
the SQL (since MySQL also supports this).
If it's currently not possible, I hope it will be added in the future,
thx.
PS: Let me know if this suppose to be a support ticket or something.
On Behalf Of conankun
Sent: Wednesday, July 08, 2009 4:48 PM
To: doctrine-user
Subject: [doctrine-user] Custom orderBy with FIELD
Hi,
I would like to know if it's possible to do a custom orderBy with
Doctrine? In other words, is there any Doctrine equivalent to this
SQL:
SELECT * FROM `table` ORDER BY FIELD(id,2,5,3,6,4,1);
I know I can do a normal Doctrine_Query and traverse the results array
and do manual sorting (which is my current alternative), however it
would be good if I can just grab the custom sorted data straight from
the SQL (since MySQL also supports this).
If it's currently not possible, I hope it will be added in the future,
thx.
PS: Let me know if this suppose to be a support ticket or something.
> On Behalf Of conankun
> Sent: Wednesday, July 08, 2009 4:48 PM
> To: doctrine-user
> Subject: [doctrine-user] Custom orderBy with FIELD
> Hi,
> I would like to know if it's possible to do a custom orderBy with
> Doctrine? In other words, is there any Doctrine equivalent to this
> SQL:
> SELECT * FROM `table` ORDER BY FIELD(id,2,5,3,6,4,1);
> I know I can do a normal Doctrine_Query and traverse the results array
> and do manual sorting (which is my current alternative), however it
> would be good if I can just grab the custom sorted data straight from
> the SQL (since MySQL also supports this).
> If it's currently not possible, I hope it will be added in the future,
> thx.
> PS: Let me know if this suppose to be a support ticket or something.
|
