Doctrine 2 mysql FIELD function in order by

by

Jeremy Hicks, thanks for your extension.
I didn`t know how to connect your function to doctrine, but finally i find answer.

$doctrineConfig = $this->em->getConfiguration();
$doctrineConfig->addCustomStringFunction('FIELD', 'DoctrineExtensions\Query\Mysql\Field');

I need FIELD function to order my Entities that i select by IN expression. But you can use this function only in SELECT, WHERE, BETWEEN clause, not in ORDER BY.

Solution:

$qb
            ->select("r, field(r.id, " . implode(", ", $ids) . ") as HIDDEN field")
            ->from("Entities\Round", "r")
            ->where($qb->expr()->in("r.id", $ids))
            ->orderBy("field");

To avoid adding field alias into your result row you need put HIDDEN keyword. So this how to be able order values in IN expression in Doctrine 2.2.

More Related Contents:

  1. How to remove leading and trailing whitespace in a MySQL field?
  2. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  3. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  4. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  5. how to get result form mysql query in specific ids [closed]
  6. mysql error cant fix the error [duplicate]
  7. Why can’t this entry be added because of Foreign Key error?
  8. MySQL pivot row into dynamic number of columns
  9. MySQL AUTO_INCREMENT does not ROLLBACK
  10. What’s the difference between MyISAM and InnoDB? [duplicate]
  11. Create new user in MySQL and give it full access to one database
  12. Most efficient way to get table row count
  13. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  14. Allow all remote connections, MySQL
  15. Import CSV to MySQL
  16. MySQL Install: ERROR: Failed to build gem native extension
  17. MYSQL syntax not evaluating not equal to in presence of NULL
  18. Getting data for histogram plot
  19. How do I populate a MySQL table with many random numbers?
  20. MySQL loop through tables
  21. INSERT INTO or UPDATE with two conditions
  22. How to determine which database is selected
  23. How to remove constraints from my MySQL table?
  24. Defining Composite Key with Auto Increment in MySQL
  25. How to use Table output from stored MYSQL Procedure
  26. Get total hours worked in a day mysql
  27. MySQL throws Incorrect string value error
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment