Actions
Feature #84814
closed
Support literal orderBy clauses
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2018-04-20
Due date:
% Done:
0%
Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:
Description
With the QueryBuilder it's currently not possible to do orderings that go beyond simple field list, i.e. something like in these real-life examples:
ORDER BY FIELD(eventtype, 0, 4, 1, 2, 3), sorting
or
ORDER BY CAST(SUBSTRING_INDEX(c.IP, '.', -1) AS UNSIGNED)
There should be something equivalent to selectLiteral for orderBy.
Without this, it can be difficult to properly migrate extensions from $GLOBALS['TYPO3_DB'] to Doctrine DBAL syntax.
Updated by 
Updated by 
Updated by
Actions