Actions
Bug #81353
closed
Query errors in StaticRecordCollection
Start date:
2017-05-28
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
Using the StaticRecordCollection leads to sql errors and wont find the right results (8.7.1).
change line 163
$statement = $queryBuilder->select($this->getItemTableName() . '.*')
to
$statement = $queryBuilder->select($this->getItemTableName() . '_join.*')
change line 179
'sys_collection_entries_join.uid_local',
to
'sys_collection_entries_join.uid_foreign',
Updated by Rainer Becker almost 7 years ago
To sort the found records add
->orderBy('sys_collection_entries_join.sorting')
Updated by Morton Jonuschat almost 7 years ago
- Status changed from New to Accepted
- Assignee set to Morton Jonuschat
- Target version set to next-patchlevel
Updated by Gerrit Code Review almost 7 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53132
Updated by Gerrit Code Review almost 7 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53132
Updated by Gerrit Code Review almost 7 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53469
Updated by Tymoteusz Motylewski almost 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset ca5b8db7739f777b0d393ed2c4c72a6377a0ff3c.
Updated by
Actions