Project

General

Profile

Actions

Bug #17284

closed

no content in workspace preview when using select.selectFields

Added by gregory almost 17 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2007-05-07
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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

17284.patch (936 Bytes) 17284.patch Benni Mack, 2011-05-12 05:04

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #29783: getQuery: fields explicilty added on select <table>.* : Error: ambigious parameter uidClosedBjörn Pedersen2011-10-11

Actions
Related to TYPO3 Core - Bug #34152: stdWrap function numRows() fails in 4.6 due to wrong SELECT clauseClosedErnesto Baschny2012-02-21

Actions
Precedes TYPO3 Core - Bug #30486: Typoscript select join brokenClosed2011-09-30

Actions
Actions #1

Updated by Benni Mack almost 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.

Actions #2

Updated by Benni Mack almost 13 years ago

Now in gerrit avaiable under: http://review.typo3.org/2089

Actions #3

Updated by Benni Mack almost 13 years ago

  • Project changed from 624 to TYPO3 Core
Actions #4

Updated by Mr. Hudson almost 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

Actions #5

Updated by Mr. Hudson over 12 years ago

Patch set 3 of change Id9d1e7dcf56b5aeeec3070ff11416e82ec1bb978 has been pushed to the review server.
It is available at http://review.typo3.org/2089

Actions #6

Updated by Mr. Hudson over 12 years ago

Patch set 4 of change Id9d1e7dcf56b5aeeec3070ff11416e82ec1bb978 has been pushed to the review server.
It is available at http://review.typo3.org/2089

Actions #7

Updated by Mr. Hudson over 12 years ago

Patch set 1 of change I6b2b68ed03163e9e0d7dd281aafea8af67fec224 has been pushed to the review server.
It is available at http://review.typo3.org/4950

Actions #8

Updated by Tolleiv Nietsch over 12 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #9

Updated by Gerrit Code Review over 12 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

Actions #10

Updated by Tolleiv Nietsch about 12 years ago

  • Status changed from Under Review to Resolved
Actions #11

Updated by TO_Webmaster no-lastname-given almost 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

Actions #12

Updated by Marcus Krause almost 12 years ago

... and this is the according ticket
#34152 (stdWrap function numRows() fails in 4.6 due to wrong SELECT clause)

Actions #13

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF