[TYPO3-mvc] Big problems (Bug?) with $query-in() (little bit urgent)

[Manfred Rutschmann]

Am Mon, 27 Sep 2010 10:42:20 +0200 schrieb Marc Bastian Heinrichs:

> 
> Extbase doesn't support tca group configuration yet. [1]
> You can use select with foreign_table instead.
> 
> 
> Regards
> Marc Bastian
> 
> [1] http://forge.typo3.org/issues/6249

Thanks for the hint.

@Steffen: You`re right. With ObjectStorage it works. Shame on me. Now i
have the right model setup, the right TCA and with this i can get it
working:

$query->matching(
		$query->logicalAnd(
			$query->logicalOr(
				$query->contains('anbieter',$anbieter),
				$query->equals('anbieter',$anbieter)
			),
			$query->equals('typ',(int)2)
		)
);

If i have only one relation in the field then contains does not work based
on this produced sql:
(tx_rkcamperchecker_domain_model_preisconfig.anbieter LIKE '%,3,%' OR
tx_rkcamperchecker_domain_model_preisconfig.anbieter LIKE '%,3' OR
tx_rkcamperchecker_domain_model_preisconfig.anbieter LIKE '3,%') 

So i have place a logicalOr and check for contains or equals by hand.

So many thanks for your brains guys.

With kind regards
Manne