Bug #17284
closed
no content in workspace preview when using select.selectFields
100%
Description
Looking for performance, i always restrict fields used in my select clause thanks to selectFields that way :
select.selectFields = header,bodytext // example which only fetch bodytext and header fields
The problem with this method is that my CONTENT won't retrieve any content in case i'm not in LIVE workspace. In my opinion, this is not the intended behaviour, since the selectFields function should take into account workspaces.
(issue imported from #M5575)
Files
Updated by Benni Mack over 13 years ago
- File 17284.patch 17284.patch added
- Category deleted (
Miscellaneous) - Status changed from Accepted to Under Review
- Target version deleted (
0)
Attached is a patch that fixes this issue.
Updated by Benni Mack over 13 years ago
Now in gerrit avaiable under: http://review.typo3.org/2089
Updated by Mr. Hudson over 13 years ago
Patch set 2 of change Id9d1e7dcf56b5aeeec3070ff11416e82ec1bb978 has been pushed to the review server.
It is available at http://review.typo3.org/2089
Updated by Mr. Hudson over 13 years ago
Patch set 3 of change Id9d1e7dcf56b5aeeec3070ff11416e82ec1bb978 has been pushed to the review server.
It is available at http://review.typo3.org/2089
Updated by Mr. Hudson about 13 years ago
Patch set 4 of change Id9d1e7dcf56b5aeeec3070ff11416e82ec1bb978 has been pushed to the review server.
It is available at http://review.typo3.org/2089
Updated by Mr. Hudson about 13 years ago
Patch set 1 of change I6b2b68ed03163e9e0d7dd281aafea8af67fec224 has been pushed to the review server.
It is available at http://review.typo3.org/4950
Updated by Tolleiv Nietsch about 13 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset e13d917ec8531d572fba295c7cbc06f44ea16750.
Updated by Gerrit Code Review about 13 years ago
- Status changed from Resolved to Under Review
Patch set 3 for branch TYPO3_4-5 has been pushed to the review server.
It is available at http://review.typo3.org/4950
Updated by Tolleiv Nietsch over 12 years ago
- Status changed from Under Review to Resolved
Applied in changeset 3fdaf5bef19cac2064ab03f746177c0bcfbe14a1.
Updated by TO_Webmaster no-lastname-given over 12 years ago
This solution breaks aggregate functions. Especially, the TypoScript method numRows causes an SQL error:
Mixing of GROUP columns (MIN,MAX,COUNT,...) with no GROUP columns is illegal if there is no GROUP BY clause
Updated by Marcus Krause over 12 years ago
... and this is the according ticket
#34152 (stdWrap function numRows() fails in 4.6 due to wrong SELECT clause)