Review main Merged Breaking

2189[TASK][!!!] Improve Backend search

Dmitry Dulepov CR +2 V +2 Normal +102 −42 updated 06/03/13, 20:49

Commit message

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 and forces DAM to make an
  XCLASS
* 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. This task solves all
described issues.

After this change extensions will need to explicitely mark their tables
as searchable. Until that, those table will not be searched.

Search by default is NOT case sensitive. If the developer wants a case
sensitive search on the column, (s)he should ensure proper locale on
that column (as described at http://bit.ly/1zw8dC) and mark the column
as case-sensitive for search (see TYPO3 core API for more details).

Review

  • Code review CR +2

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V +2

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 6