Feature #75017
open
Search for relations in backend
0%
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
Updated by Markus Hölzle over 8 years ago
This part of the core should be migrated to doctrine before we can implement this feature (to avoid implementing this twice).
See #76259
Updated by Benno Flory over 8 years ago
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?
Updated by Gerrit Code Review over 8 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/49341
Updated by Markus Hölzle over 8 years ago
- Sprint Focus set to On Location Sprint
Updated by Gerrit Code Review about 8 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/49341
Updated by Gerrit Code Review about 8 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49341
Updated by Susanne Moog over 7 years ago
- Sprint Focus deleted (
On Location Sprint)
Updated by Markus Hölzle almost 7 years ago
- Related to Bug #83261: List View sorting by category is done by category id instead of titles added
Updated by Susanne Moog over 5 years ago
- Status changed from Under Review to New
Review was abandoned.
Updated by Susanne Moog over 4 years ago
- Category set to Backend User Interface
Updated by Daniel Windloff about 4 years ago
- Related to Story #82206: list module enhancements/bugfixes added
Updated by Jan Kornblum 6 months ago
· Edited
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 :(
Updated by Jan Kornblum 6 months ago
- Related to Epic #93547: Collection of problems with large sites added