Actions
Bug #74295
open
parseComparison doesn't accept fields without relation for use with contains()
Status:
New
Priority:
Should have
Assignee:
-
Category:
Extbase
Target version:
-
Start date:
2016-03-05
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:
Description
In the query builder you can use contains() for fields with a relation or for fields that are of type 'select' and have maxitems > 1. There are also other fields (such as 'keywords') which contain comma separated values, but do not have a relation and are not of type 'select'. For these fields a beautiful exception is thrown.
The alternative for such fields is to use the LIKE monstrosity (field LIKE '%,keyword,%' OR field LIKE '%,keyword' OR field LIKE 'keyword,%' or field = 'keyword') which will probably be even worse performance wise than a FIND_IN_SET().
No data to display
Actions