Bug #74295

parseComparison doesn't accept fields without relation for use with contains()

Added by Jigal van Hemert almost 5 years ago.

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

Also available in: Atom PDF