Feature #75017
open
Search for relations in backend
Added by Markus Hölzle over 8 years ago.
Updated 6 months ago.
Category:
Backend User Interface
Description
Hey there,
I've got a feature request for the TYPO3 backend list module: Search for relations.
An example:
I've got two tables: "car" and "manufacturer".
Every "car" has a relation to the "manufacturer" (every car has one or more "manufacturer" for example).
Now, the backend user wants to list all cars from the manufacturer "VW" for example and search for "VW".
-> This does not work until now
(This is a really unexpected and strange behaviour for the users...)
The reason is: the TYPO3 backend searches only in the table "car", in fields with the TCA config type "text", "flex" and "input" (see \TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList::makeSearchString).
What do you think? Should there a feature like this? Will this feature be added to the core if I contribute it?
Regards,
Markus
Related issues
3 (3 open — 0 closed)
This part of the core should be migrated to doctrine before we can implement this feature (to avoid implementing this twice).
See #76259
We have the same requirement from current customers, e.g. orders <-> customers. Would be great to implement that asap...
If we want a workaround now, we would have to implement a custom backend module, right?
- Status changed from New to Under Review
- Sprint Focus set to On Location Sprint
- Sprint Focus deleted (
On Location Sprint)
- Related to Bug #83261: List View sorting by category is done by category id instead of titles added
- Status changed from Under Review to New
- Category set to Backend User Interface
- Related to Story #82206: list module enhancements/bugfixes added
I think this still would be an important improvement! Especially if implementation also would optimize TCA "select" fields (selectMultipleSideBySide), to be able to filter items by their relations. I currently have to deal with ~30.000 "event" records which have <n:1> relations to "seminar" and "location". Due to the missing possibility to search records by those relation columns, it is very hard to access specific records using the standard BE list module or to assign specific records to e.g. „ selectMultipleSideBySide“ fields :(
- Related to Epic #93547: Collection of problems with large sites added
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by