Actions
Bug #81157
closed
Typoscript SELECT: orderBy = rand() fails
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'
Updated by Paul Hansen over 6 years ago
Try this:
select.orderBy = rand()
select.selectFields = pages.*,rand()
Updated by Steffen Müller over 5 years ago
This usecase is documented in the DatabaseQueryProcessor class of frontend sysext.
Updated by
Updated by Benni Mack over 4 years ago
- Status changed from New to Closed
I will close this now, as we won't fix this edge case for v8 anymore (already in Priority Bugfix / Security Bugfix mode). If you have any further questions, reach out to me so I can re-open the issue.
Actions