#48701setChildTableName regards only $columnConfiguration['foreign_table']
Description
in Tx_Extbase_Persistence_Mapper_DataMapFactory
functions
setOneToOneRelation
setOneToManyRelation
setManyToManyRelation
$columnMap->setChildTableName($columnConfiguration[‘foreign_table’]);
but the TCA type ‘group’, internal_type ‘db’, does not necessarily provide a ‘foreign_table’ attribute, ‘allowed’ is sufficient for the table relation. But this causes an SQL Error if you make statements like
constraints[] = $query->like(‘property.relatedProperty’, ‘‘ . $searchVar . ‘’);
because the table of the property for the join is not provided in the SQL Statement
Error occurs in Version 4.7 and 6.1. Maybe fixed in the meantime. But the lines of code in the DataMapFactory are still the same.
The workaround is to set the foreign_table attribute in the TCA also for the ‘group’ type. But maybe a better solution directly in extbase would be nice?
Since this is my first report, please tell me if there is something I should do better?
Reviews 2
Related issues 1
History 1117
-
Alexander Schnitzler commented <span data-processor="relativetime" data-value="2013-05-31T15:07:28+00:00" > 05/31/13, 15:07 </span>
-
Anja Leichsenring changed target version <span data-processor="relativetime" data-value="2013-05-31T15:28:33+00:00" > 05/31/13, 15:28 </span>
-
Alexander Opitz changed project id category target version TYPO3 Version 7 Is Regression 0 <span data-processor="relativetime" data-value="2014-12-08T12:29:20+00:00" > 12/08/14, 12:29 </span>
-
Mathias Schreiber changed target version <span data-processor="relativetime" data-value="2014-12-23T19:46:37+00:00" > 12/23/14, 19:46 </span>
-
Benni Mack changed target version <span data-processor="relativetime" data-value="2015-06-15T17:44:58+00:00" > 06/15/15, 17:44 </span>
-
Susanne Moog changed target version <span data-processor="relativetime" data-value="2015-08-05T10:25:18+00:00" > 08/05/15, 10:25 </span>
-
Benni Mack changed target version <span data-processor="relativetime" data-value="2015-09-24T19:21:53+00:00" > 09/24/15, 19:21 </span>
-
Stefan Froemken commented <span data-processor="relativetime" data-value="2023-06-16T18:22:51+00:00" > 06/16/23, 18:22 </span>
Hello,
yes, would be cool to have such a solution in extbase.
For now I have helped me with TYPO3 QueryBuilder and $query->statement():Stefan
-
Gerrit Code Review pushed patch set 1 for main to change 88898 status
NewUnder Review <span data-processor="relativetime" data-value="2025-04-02T07:12:05+00:00" > 04/02/25, 07:12 </span> -
Gerrit Code Review pushed patch set 2 for main to change 88898 <span data-processor="relativetime" data-value="2025-04-02T09:38:23+00:00" > 04/02/25, 09:38 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 88898 <span data-processor="relativetime" data-value="2025-04-02T10:04:56+00:00" > 04/02/25, 10:04 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 88898 <span data-processor="relativetime" data-value="2025-04-02T10:36:30+00:00" > 04/02/25, 10:36 </span>
-
Benni Mack commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-04-07T19:55:08+00:00" > 04/07/25, 19:55 </span>Applied in changeset commit:3f1a68654cbea25438a543b66a1722563fe6a2df.
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 88967 status
ResolvedUnder Review <span data-processor="relativetime" data-value="2025-04-07T19:56:05+00:00" > 04/07/25, 19:56 </span> -
Gerrit Code Review pushed patch set 2 for 13.4 to change 88967 <span data-processor="relativetime" data-value="2025-04-07T20:01:07+00:00" > 04/07/25, 20:01 </span>
-
Benni Mack commented and changed status
Under ReviewResolved <span data-processor="relativetime" data-value="2025-04-08T08:30:11+00:00" > 04/08/25, 08:30 </span>Applied in changeset commit:965c9c4a33f9b0257fae96a9bae0b1a6c5aef51d.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:36:42+00:00" > 12/02/25, 14:36 </span>
See related issue(s). Its known to us.