#108534Using 'ORDERBY' in 'foreign_table_where' has no effect
Description
TCA select fields currently ignore ORDERBY in foreign_table_where.
// EXT:sitepackage/Configuration/TCA/Overrides/sys_category.php
// Order category tree by sys_category.sorting column
$GLOBALS['TCA']['sys_category']['columns']['parent']['config']['foreign_table_where'] = ' AND {#sys_category}.{#sys_language_uid} IN (-1, 0) ORDER BY sys_category.sorting ASC';
Since #106502 AbstractItemProvider->buildForeignTableQueryBuilder() use an innerJoin to retrieve the full records using column wildcard.
Foreign table ORDERBY statements or default sorting from TCA are applied to $queryBuilder (used as sub-query in $wrapQueryBuilder), but not the returned $wrapQueryBuilder.
- Commit 75a14ee
- Task #106502
Imho orderBy should be removed from the sub-query ($queryBuilder; L665 to 678) and added to $wrapQueryBuilder.
// EXT:backend/Classes/Form/FormDataProvider/AbstractItemProvider.php#L748
// Add orderings
$orderByClauses = [];
if (!empty($foreignTableClauseArray['ORDERBY'])) {
$orderByClauses = $foreignTableClauseArray['ORDERBY'];
} elseif ($schema->hasCapability(TcaSchemaCapability::DefaultSorting)) {
$orderByClauses = QueryHelper::parseOrderBy($schema->getCapability(TcaSchemaCapability::DefaultSorting)->getValue());
}
foreach ($orderByClauses as $orderPair) {
[$fieldName, $order] = $orderPair;
// Remove table name
if (str_contains($fieldName, '.')) {
$fieldName = substr($fieldName, strpos($fieldName, '.') + 1);
}
// Append 'joined_table'
$fieldName = 'joined_table.' . $fieldName;
$wrapQueryBuilder->addOrderBy($fieldName, $order);
}
return $wrapQueryBuilder;Reviews 1
Related issues 1
History 47
-
Georg Tiefenbrunn changed Related to #106502 <span data-processor="relativetime" data-value="2025-12-19T12:29:09+00:00" > 12/19/25, 12:29 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 92231 status
NewUnder Review <span data-processor="relativetime" data-value="2025-12-29T17:03:20+00:00" > 12/29/25, 17:03 </span> -
Markus Klein changed Duplicated by #108765 <span data-processor="relativetime" data-value="2026-01-25T23:59:56+00:00" > 01/25/26, 23:59 </span>
-
Gerrit Code Review pushed patch set 2 for main to change 92231 <span data-processor="relativetime" data-value="2026-03-12T09:56:16+00:00" > 03/12/26, 09:56 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 92231 <span data-processor="relativetime" data-value="2026-03-12T10:47:52+00:00" > 03/12/26, 10:47 </span>
-
Anonymous commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-03-12T11:45:09+00:00" > 03/12/26, 11:45 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2026-03-31T08:59:33+00:00" > 03/31/26, 08:59 </span>
Applied in changeset commit:16c5344e552329870e8fceaf9a6d3bb7b12d1678.