[TYPO3-mvc] MM relation / foreign_table_where gets ignored

[Ingo Franzen]

Hello Franz,

I really appreciate it if you would have a look on this matter.

I also looked into the DataMapFactory of extbase and foreign_table_where 
seems to be added to the columsMap properties for MM relations, but this 
is a more a guess becaus I am not that familiar with the extbase core.

Thanks again,
Ingo

Am 24.03.2011 11:33, schrieb Franz Koch:
> Hey,
>
>> 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'
>> ),
>> ),
>
> from what I remembered you can adjust the default sorting of properties
> by using foreign_table_where - but I can be wrong. Need to have a look
> again.
>