[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