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

[JoH asenau]

> select * FROM tx_ebbolig_afdeling INNER JOIN pages ON
> tx_ebbolig_afdeling.pid = pages.pid WHERE pages.uid = 65;
>
> Where 65 is the uid where my subitems is located. It, as it should,
> returns the items from the parent folder.
>
> I have tried to make the same sql in my TCA like this:
>
> "foreign_table" => "tx_ebbolig_afdeling",
> "foreign_table_where" => "AND pages.uid=###CURRENT_PID### ORDER BY
> tx_ebbolig_afdeling.uid",
>
> But this doesnt work. I get an empty select box.

Could you please explain the structure.
What I understood is this:

Sysfolder
    Item 1
    Item 2
    Sysfolder
        Item A
        Item B

And you want a relation between
Item 1 <=> Item A
Item 2 <=> Item A
Item 1 <=> Item B
Item 2 <=> Item B

Something like that?

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
openBC/Xing: http://www.cybercraft.de
T3 cookbook: http://www.typo3experts.com