Project

General

Profile

Actions

Feature #79054

closed

Custom Order By Clause

Added by Harald Holzmann almost 8 years ago. Updated over 4 years ago.

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
)
);


Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Feature #32051: Concat ordering for Database requestNew2011-11-24

Actions
Actions

Also available in: Atom PDF