Project

General

Profile

Actions
Copy link

Bug #82955

closed

Doctrine: foreign_table_where cannot handle ORDER BY FIELD/ORDER BY FIND_IN_SET

Added by Benni Mack over 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2017-11-09
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

The parser used in AbstractItemProvider for FormEngine does not allow values like:

foreign_table='tx_mytable',
foreign_table_where='ORDER BY FIELD(belongstogroup, "system", "loudspeaker", "dsp", "controls", "inputs", "outputs", "network", "conditions", "connectors", "datalinear", "power", "dimensions"), title;'

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #88166: TCA entry 'foreign_table_where' => ' ORDER BY LOWER(tx_my_table.name) ASC' not working anymoreClosed2019-04-17

Actions
Actions
Copy link

Also available in: Atom PDF