Bug #31209


CONTENT still can't select records from rootpage

Added by Joh. Feustel over 12 years ago. Updated about 12 years ago.

Should have
Target version:
Start date:
Due date:
% Done:


Estimated time:
TYPO3 Version:
PHP Version:
Is Regression:
Sprint Focus:


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 {
    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

Related issues 6 (0 open6 closed)

Related to TYPO3 Core - Bug #20412: CONTENT can't select records from rootpageClosedBenni Mack2009-05-09

Related to TYPO3 Core - Bug #19762: Traversing back page records used in CONTENT object does not work on root pageClosedOliver Hader2009-01-03

Related to TYPO3 Core - Bug #32374: MENU special = updated not working in 4.6ClosedXavier Perseguers2011-12-07

Related to TYPO3 Core - Task #57168: Enable queries using "root" and "-1" for pidInListClosedOliver Hader2014-03-21

Has duplicate TYPO3 Core - Bug #32212: select.pidInList = 0 won't select records with pid = 0Closed2011-11-30

Has duplicate TYPO3 Core - Bug #33220: Empty content object when select.pidInList=0 set in TSClosed2012-01-16

Actions #1

Updated by Myroslav Holyak over 12 years ago

It seems to be resolved in current trunk. Hopefully it will be released in 4.6.1

Actions #2

Updated by Joh. Feustel over 12 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.

Actions #3

Updated by Andreas Bouche over 12 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.

Actions #4

Updated by Myroslav Holyak about 12 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?

Actions #5

Updated by Soeren Kracker about 12 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

Actions #6

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

Actions #7

Updated by Ernesto Baschny about 12 years ago

Meanwhile, the solution for #32374 was merged in (4.6) and (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.


Actions #8

Updated by Markus Klein about 12 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".


Actions #9

Updated by Ernesto Baschny about 12 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.

Actions #10

Updated by Xavier Perseguers about 12 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF