Project

General

Profile

Actions

Task #26829

closed

Improve Backend search

Added by Dmitry Dulepov almost 13 years ago. Updated almost 11 years ago.

Status:
Closed
Priority:
Should have
Category:
Backend User Interface
Target version:
-
Start date:
2011-05-16
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.6
PHP Version:
5.3
Tags:
Complexity:
Sprint Focus:

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).


Files

search-trunk.diff (21.8 KB) search-trunk.diff Dmitry Dulepov, 2011-05-16 11:03

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #31761: Live search does not implement search propertiesClosedFrancois Suter2011-11-11

Actions
Actions #1

Updated by Mr. Hudson almost 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

Actions #2

Updated by Mr. Hudson almost 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

Actions #3

Updated by Oliver Hader almost 13 years ago

  • Target version changed from 1238 to 1281
Actions #4

Updated by Mr. Hudson almost 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

Actions #5

Updated by Dmitry Dulepov almost 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

Actions #6

Updated by Mr. Hudson almost 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

Actions #7

Updated by Mr. Hudson almost 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

Actions #8

Updated by Mr. Hudson almost 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

Actions #9

Updated by Mr. Hudson almost 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

Actions #10

Updated by Dmitry Dulepov almost 13 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 90 to 100
Actions #11

Updated by Xavier Perseguers about 12 years ago

  • Status changed from Resolved to Closed
Actions #12

Updated by Ernesto Baschny almost 11 years ago

  • Target version deleted (1281)
Actions

Also available in: Atom PDF