[TYPO3-english] extbase: searching in a list field
Arno Dudek
webmaster at adgrafik.at
Wed Apr 25 11:18:50 CEST 2012
Hi List!
How can I search comma seperated list with extbase?
For this I have a field in the DB and TCA is defined as
'run' => array(
'exclude' => 1,
'label' => 'Wake-Up Run',
'config' => array(
'type' => 'select',
'size' => 4,
'maxitems' => 4,
'multiple' => TRUE,
'selicon_cols' => 0,
'items' => array(
array('27', 27),
array('28', 28),
array('29', 29),
array('30', 30),
),
)
),
Here you can select one or more items. In the DB the values stored like
"27,29". So far correct.
Now I want to search only for the value "27". And tryed with
$query->contains('run', 27)
But I got the message "1267832524: Unsupported relation for contains"
Please help me!
lg arno
More information about the TYPO3-english
mailing list