[TYPO3-mvc] MM relation / foreign_table_where gets ignored

[Ingo Franzen]

Hello :)

> Hi,
>
> AFAIR, Extbase does not use the foreign_table_where setting, because you
> can write ANY SQL statement in there.

hmm, I am not sure what Franz meant then when he said this:

you have to define the default sorting/ordering for the property itself, 
not in the ctrl-section of the table.

'yourColumnName' => array(
    'config' => array(
      'foreign_table' => 'tx_yourext_domain_model_table',
      'foreign_table_where' => ' ORDER BY
tx_yourext_domain_model_table.childProperty ASC'
    ),
),


see:
http://lists.typo3.org/pipermail/typo3-project-typo3v4mvc/2011-March/008798.html


Greetings,
Ingo