Project

General

Profile

Actions

Task #26829

closed

Improve Backend search

Added by Dmitry Dulepov over 13 years ago. Updated over 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 2 (1 open1 closed)

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

Actions
Related to TYPO3 Core - Task #104539: Dynamically limit livesearch to searchFields used in subtypesUnder ReviewKevin Appelt2024-08-02

Actions
Actions

Also available in: Atom PDF