#107796Add table in searchContraint for DatabaseRecordList
Description
The other day, using TYPO3 10 + 11, I had to update the “makeSearchString” of DatabaseRecordList to include fields from a joined table in the search.
I had no issue up until a MySQL error “Column ‘name’ in field list is ambiguous”. This is because the constraint build in “makeSearchString” don’t use the current “$table“
clipboard-202510210900-co3uh.png
And since you can’t read the data from “CompositeExpression” from the queryBuilder constraints, you can’t add the table for an easy fix.
The workaround was to remove the field “name” in my TCA [‘ctrl’][‘searchFields’] and add it back in my hook with the table written.
clipboard-202510210905-4kywo.png
Since TYPO3 provide a hook, or an event in newer versions, I think it’s normal that the table name is provided by default in the where clause.
Reviews 3
Related issues 1
Files 2
History 410
-
Ludovic Nogueira changed target version <span data-processor="relativetime" data-value="2026-03-04T08:05:13+00:00" > 03/04/26, 08:05 </span>
-
Ludovic Nogueira commented and changed tracker
FeatureBug TYPO3 Version 14 <span data-processor="relativetime" data-value="2026-03-04T08:05:41+00:00" > 03/04/26, 08:05 </span> -
Gerrit Code Review pushed patch set 1 for main to change 93054 status
NewUnder Review <span data-processor="relativetime" data-value="2026-03-04T08:34:49+00:00" > 03/04/26, 08:34 </span> -
Gerrit Code Review pushed patch set 2 for main to change 93054 <span data-processor="relativetime" data-value="2026-03-04T09:43:50+00:00" > 03/04/26, 09:43 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 93054 <span data-processor="relativetime" data-value="2026-04-22T06:42:26+00:00" > 04/22/26, 06:42 </span>
-
Markus Klein changed Related to #75017 <span data-processor="relativetime" data-value="2026-04-27T15:25:14+00:00" > 04/27/26, 15:25 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 93054 <span data-processor="relativetime" data-value="2026-05-02T15:19:15+00:00" > 05/02/26, 15:19 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 93909 <span data-processor="relativetime" data-value="2026-05-02T15:21:34+00:00" > 05/02/26, 15:21 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 93910 <span data-processor="relativetime" data-value="2026-05-02T15:21:50+00:00" > 05/02/26, 15:21 </span>
-
Anonymous commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-05-02T15:50:09+00:00" > 05/02/26, 15:50 </span>Applied in changeset commit:18326315ff8d8e787b7b6ace97bde5a3df959b36.
(all typo3 versions below the 14, tested since v9)