Bug #82955: Doctrine: foreign_table_where cannot handle ORDER BY FIELD/ORDER BY FIND_IN_SET - TYPO3 Core - TYPO3 Forge

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:

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)

Actions

Copy link

Updated by Susanne Moog about 4 years ago

Description updated (diff)

Actions

Copy link

Updated by Gerrit Code Review about 4 years ago

Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/63755

Actions

Copy link

Updated by Susanne Moog about 4 years ago

Related to Bug #88166: TCA entry 'foreign_table_where' => ' ORDER BY LOWER(tx_my_table.name) ASC' not working anymore added

Actions

Copy link

Updated by Gerrit Code Review about 4 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/63755

Actions

Copy link

Updated by Gerrit Code Review about 4 years ago

Patch set 1 for branch 9.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/63858

Actions

Copy link