Bug #42177

Backend-Search: Using search-words which can be interpreted as integer.

Added by sunixzs no-lastname-given almost 3 years ago. Updated 10 months ago.

Status:Resolved Start date:2012-10-19
Priority:Should have Due date:
Assigned To:- % Done:

0%

Category:Backend API Spent time: -
Target version:-
TYPO3 Version:4.7 Is Regression:No
PHP Version:5.3 Sprint Focus:
Complexity:

Description

Hello Core-Team,

since typo3 4.6.0, i think, there is a new implementation of the backend search, which is find in module page or list on every page in the bottom.

There is a difference between searching for words which can be interpreted as integers or not.

The problem:
For example there is a database-table with a field named zipcode. The zipcode-field is defined as a varchar-field, because a zipcode can start with a 0 like "01234". If the field is of type integer, it is not possible to store "01234".

If I try to search for 01234 it is interpreted as integer and the text-field zipcode is ignored while search.

I think the problem could be find in the implementation of the searchString:
File: typo3/class.db_list.inc Method: makeSearchString().

Unfortunately I'm not able to fix something like this and present a patch. For my project I've modified this method to make no equal-parts on integer-interpreted-strings. Now always a like-part is generated ignoring the type/eval-setting in the TCA. (I think this is the way before typo3 4.6.0 and therefore no improvement.)

Thank you for your attention and ignore my bad english writing ;-)
And thank you for typo3 - I like it much - great work.


Related issues

duplicates Core - Bug #33700: Invalid behavior of search for integer in Backend search Resolved 2012-02-06

History

#1 Updated by Patrick Schriner about 2 years ago

I think this has been fixed with #33700.

#2 Updated by Felix Kopp 10 months ago

  • Status changed from New to Resolved
  • Is Regression set to No

Also available in: Atom PDF