Task #26829
closedImprove Backend search
100%
Description
- 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).
Files
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Mr. Hudson over 13 years ago
Patch set 2 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Oliver Hader over 13 years ago
- Target version changed from 1238 to 1281
Updated by Mr. Hudson over 13 years ago
Patch set 3 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Dmitry Dulepov over 13 years ago
- Category set to Backend User Interface
- Status changed from New to Under Review
- Assignee set to Dmitry Dulepov
- % Done changed from 30 to 90
- PHP Version set to 5.3
The patch attached here is no longer relevant. Please, get the patch from http://bit.ly/k7LeXT
Updated by Mr. Hudson over 13 years ago
Patch set 4 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Mr. Hudson over 13 years ago
Patch set 5 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Mr. Hudson over 13 years ago
Patch set 6 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Mr. Hudson over 13 years ago
Patch set 7 of change I2b194dc1c746a4fc3f7663358ed08d7c9f6e11a8 has been pushed to the review server.
It is available at http://review.typo3.org/2189
Updated by Dmitry Dulepov over 13 years ago
- Status changed from Under Review to Resolved
- % Done changed from 90 to 100
Applied in changeset 7b3d5b97ed9e00af4eb08b7e59c7311b5ed72e15.
Updated by Xavier Perseguers over 12 years ago
- Status changed from Resolved to Closed
Updated by Kevin Appelt 4 months ago
- Related to Task #104539: Dynamically limit livesearch to searchFields used in subtypes added