Bug #31209
CONTENT still can't select records from rootpage
Status: | Closed | Start date: | 2011-10-24 | |
---|---|---|---|---|
Priority: | Should have | Due date: | ||
Assigned To: | - | % Done: | 0% |
|
Category: | TypoScript | Spent time: | - | |
Target version: | 4.6.4 | |||
TYPO3 Version: | 4.6 | Is Regression: | ||
PHP Version: | Sprint Focus: | |||
Complexity: |
Description
The Problem described in #20412 still exists.
"If you use the "CONTENT" TypoScript object, to retrieve records from the root-page - like "static_countries", etc. This is currently not possible."
The following code will return nothing since checkPidArray() checks for existing pages and removes 0 from pidInList
10 = CONTENT 10 { table = static_countries select { pidInList = 0 selectFields = uid, cn_iso_3, cn_official_name_en } renderObj= TEXT renderObj { wrap = <li>|</li> field = cn_official_name_en } }
Obviously there as been a Fix for this Problem which has been reverted in SVN Trunk (rev. 6146) see http://forge.typo3.org/issues/19762#note-3
Related issues
History
#1 Updated by Myroslav Holyak over 3 years ago
It seems to be resolved in current trunk. Hopefully it will be released in 4.6.1
#2 Updated by Joh. Feustel over 3 years ago
Hi Myroslav,
could you point me to the corresponding issue or patch in gerrt? i would like to review and test this but cannot find anything while it still is not working for me with latest checkout.
#3 Updated by Andreas Bouche over 3 years ago
- Target version set to 4.6.2
Unfortunately this has not been fixed with the release of 4.6.1.
In my opinion this should be a "must have". There are definitely a lot of Extensions that rely on this Feature. Also this is the common way for building language or country selects in Formhandler or Form. This ist not possible at the moment and should be fixed as soon as possible.
I will try to submit a patchset for this soon.
#4 Updated by Myroslav Holyak over 3 years ago
Well, i'll better stay on 4.5.latest till this issue will be fixed... Just curious - shouldn't be such core-functionality covered with unit tests to avoid such errors?
#5 Updated by Soeren Kracker over 3 years ago
- Target version changed from 4.6.2 to 4.6.3
It's still not fixed in 4.6.2.
The linked fix wouldn't give attention to other tables than pages anyway. In my case I need to set pidInList = 0 and table = static_countries
#6 Updated by Gerrit Code Review over 3 years ago
- Status changed from New to Under Review
Patch set 3 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/7826
#7 Updated by Ernesto Baschny over 3 years ago
Meanwhile, the solution for #32374 was merged in http://review.typo3.org/7839 (4.6) and http://review.typo3.org/7739 (4.7 = master).
Please check if this solves your particular problem, if it does, we might add a "duplicate" tag to this and close it.
Thanks!
#8 Updated by Markus Klein over 3 years ago
Hi Ernesto,
as you can see in Gerrit, I've already abandoned my changeset.
Feel free to close this issue or mark it as resolved.
I've added #32374 as related, since the titles of the issues do not really sound like "duplicates".
Cheers
#9 Updated by Ernesto Baschny over 3 years ago
- Category set to TypoScript
- Status changed from Under Review to Resolved
- Target version changed from 4.6.3 to 4.6.4
Resolved with the same fix already merged in #32374.
#10 Updated by Xavier Perseguers over 3 years ago
- Status changed from Resolved to Closed