Bug #45703
closedmethod exec_foreign_table_where_query don't respect rootLevel
100%
Description
Hello Core-Team,
I'm using the TCA tree feature for my own table. This table is defined as rootLevel = -1. That means you can set records of this table on rootPage and all other pages. But there is a problem in method exec_foreign_table_where_query. You wrote:
if ($rootLevel) { $queryParts = array( 'SELECT' => self::getCommonSelectFields($foreign_table, $foreign_table . '.'), 'FROM' => $foreign_table, 'WHERE' => $foreign_table . '.*pid=0* ' . self::deleteClause($foreign_table) . ' ' . $wgolParts['WHERE'], 'GROUPBY' => $wgolParts['GROUPBY'], 'ORDERBY' => $wgolParts['ORDERBY'], 'LIMIT' => $wgolParts['LIMIT'] ); }
If rootLevel equals 1 this code works correct with pid=0. But it will also be executed with rootLevel=-1. But in that case pid=0 must be pid<>-1 or should be deleted completely.
Stefan
Updated by Gerrit Code Review almost 12 years ago
- Status changed from New to Under Review
Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18417
Updated by Gerrit Code Review over 11 years ago
Patch set 2 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18417
Updated by Gerrit Code Review over 11 years ago
Patch set 1 for branch TYPO3_6-0 has been pushed to the review server.
It is available at https://review.typo3.org/18976
Updated by Stefan Froemken over 11 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 49b6aef305527bc56bd2325dfe199ef117a344e1.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed