Actions
Feature #79054
closedCustom Order By Clause
Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Extbase
Target version:
-
Start date:
2016-12-20
Due date:
% Done:
0%
Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:
Description
Hello,
in a Repository I will sort the result by a custom clause. For example I will search the nearest value. For this I calculate the deviation betwenn the values and rank them by this. So the first one will be the result with the nearest value.
For this i have to use prepared statements:
SOME SQL +order by ABS limit 1;
Would be nice if in the repository i could use something like:
$query->setOrderings(
array(
'ABS' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING
)
);
Actions