Warum baut mir Extbase eine so merkwürdige SQL Abfrage zusammen?
SELECT .* FROM tx_regionalobject_robject_robject_mm LEFT JOIN ON tx_regionalobject_robject_robject_mm.uid_local = .uid WHERE (tx_regionalobject_robject_robject_mm.uid_foreign = '245' AND tx_regionalobject_robject_robject_mm.tablenames = 'tx_regionalobject_domain_model_regionalobject') ORDER BY tx_regionalobject_robject_robject_mm.sorting_foreign ASC
Mein TCA:
'config' => array(
'type' => 'group',
'internal_type' => 'db',
'allowed' => 'tx_regionalobject_domain_model_regionalobject', //add tablenames here
'show_thumbs' => true,
'maxitems' => 100,
'minitems' => 0,
'size' => 7,
'MM' => 'tx_regionalobject_robject_robject_mm',
'MM_opposite_field' => 'regional_objects',
'MM_match_fields' => array(
'tablenames' =>
),
'multiple' => false,
'wizards' => array(
'suggest' => array(
'type' => 'suggest'
)
)
Und vielleicht kann mir auch gleich einer sagen wie ich bidirektionale MM Verbindungen so erzeugen kann, dass ich im Datensatz von beiden Seiten aus die Verbindung sehe.