[TYPO3-mvc] Include MM_match_field in query statement

Peter Falk pf1 at isight.dk
Sat Sep 8 17:28:33 CEST 2012


Hi all.

How do I include the MM_match_field in a query, without having to wrote 
the whole query-statement myself?

When using contains: $query->contains( 'category', $uid ), the api add 
this to the query:

... IN (SELECT uid_local FROM misc_tx_categories_categories_mm WHERE 
uid_foreign=432), which is correct.

But because the MM-table is used in different situations, field 
tablenames must be a part of the query.

... IN(SELECT uid_local FROM misc_tx_categories_categories_mm WHERE 
uid_foreign=432 AND tablenames="tx_events_domain_model_event")



Regards
Peter


More information about the TYPO3-project-typo3v4mvc mailing list