Project

General

Profile

Actions

Bug #81157

closed

Typoscript SELECT: orderBy = rand() fails

Added by Oliver Hübner over 7 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
TypoScript
Target version:
-
Start date:
2017-05-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.1
Tags:
Typoscript, rand, rand(), select
Complexity:
Is Regression:
Sprint Focus:

Description

A Database-Query via Typoscript e.g.

...
table = pages
select {
pidInList = this
orderBy = rand()
}
...

ends with an error, because the ts get rendered the rand() in quoutes

... ORDER BY `rand()` ASC': Unknown column 'rand()' in 'order clause'

Actions

Also available in: Atom PDF