[TYPO3-dev] Alter foreign_table_where to select items from parent page

[Brian Bendtsen]

JoH asenau skrev:
> Then this won't work:
> 
> "foreign_table" => "tx_ebbolig_afdeling",
> "foreign_table_where" => "AND pages.uid=###CURRENT_PID### ORDER BY
> tx_ebbolig_afdeling.uid",
> 
> pages.uid = ###CURRENT_PID### will return Sysfolder A and not Sysfolder 1
> because the PID points to the parent page of the item itself and not the
> sysfolder containing it.
> Therefor I guess pages.uid = 65 will return a correct result, because 65 is
> the uid of Sysfolder 1. But this is not equal to ###CURRENT_PID###.
> It seems in this case you might get better results by using a real MM
> relation with an additional table.
> 
> HTH
> 
> Joey
> 
No 65 is the uid of sysFolder A

/BB