Bug #42177
Backend-Search: Using search-words which can be interpreted as integer.
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
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