#26829Improve Backend search
Description
There are several problems with current Backend search:
- it searches far more fields than necessary (for example, TSConfig)
- it searches “uid” and other numeric fields even if the value is not numeric
- it uses LIKE x search on numeric fields
- it searches all tables even if they do not make sense to be searched
- it is too slow
- it searches only first four levels deep in the page tree
All these problems come from the [wrong] idea that TYPO3 can detect where it can search. Instead, tables should be marked as “searchable” and provide a list of fields that make sense to search. Also it makes sense to search some fields as case insensitive.
The attached patch improves backend search using ideas above. It is made over git revision 69fb8866b94c75b3b73395cfa4bd0a900e6ab53c (May 10, 2011).
When applying the patch, use -p1 argument (git diff makes patches that require -p1).