[TYPO3-dev] Select from parent folder

[Brian Bendtsen]

Widmann, Manfred skrev:
> "Brian Bendtsen" <nightowl at galnet.dk> schrieb im Newsbeitrag 
> news:mailman.1.1177054917.21538.typo3-dev at lists.netfielders.de...
>> Hi
>>
>> I have making an extension where it is possible to create some items and 
>> subitems.
>>
>> When creating a subitem, you have to attach it to an item.
>>
>> I would like to place items in a sysfolder and subitems in a sysfolder 
>> inside the first one.
>>
>> How do I make it possible to select an item from a parent folder without 
>> making it a global select?
>>
>> /Brian Bendtsen
>>
> 
> Maybe I missunderstand you, but ... where sub.pid = super.uid ??? 
> 
> 
Im not sure what to do with that.

Here is the foreign key code from my tca.php where the "problem" is:

"afdelingid" => Array (		
"exclude" => 1,		
"label" => 
"LLL:EXT:eb_bolig/locallang_db.xml:tx_ebbolig_lejemaal.afdelingid",		
"config" => Array (
"type" => "select",	
"foreign_table" => "tx_ebbolig_afdeling",	
"foreign_table_where" => "AND tx_ebbolig_afdeling.pid=###CURRENT_PID### 
ORDER BY tx_ebbolig_afdeling.uid",	
"size" => 1,	
"minitems" => 0,
"maxitems" => 1,

as the foreign_table_where is here I can select between items from 
current page ID, I want to be able to select between items from the 
Parent Page ID.

Or even better, I want a user to be able to select from all accessible 
sysFolders. I cant make it a global select, since I dont want users to 
be able to select items created by another usergroup.

/BB