[TYPO3-english] Typo3 foreign_table: How to specify a specific column to a select drop down menu?

christian ewigfrost christian-kulozik at gmx.net
Tue Oct 24 09:11:27 CEST 2017


Basically a simple question (i guess):

I want to add records in the Typo3 backend. Thatfor i made an extension containing 4 different classes. While adding a record of one specific class to a folder via the backend i want to have a select that lets me chose from items of a column from another class. I know i have to use a foreign_table for this like in this code:

     'kundeuid' => array(
                                               'exclude' => 1,
                                               'label' => 'LLL:EXT:icingaconfgen/Resources/Private/Language/locallang_db.xlf:tx_icingaconfgen_domain_model_appliance.kundeuid',
                                               'config' => array(
                                                               'type' => 'select',
                                                               'renderType' => 'selectSingle',
                                                               'foreign_table' => 'tx_icingaconfgen_domain_model_kunde',
                                                               'foreign_table_where' => 'ORDER BY tx_icingaconfgen_domain_model_kunde.kundeuid asc',
                                                               'items' => array(
                                                                               array('-- Select Kunde --', 0),
                                                               ),
                                                               'size' => 1,
                                                               'maxitems' => 1
                                               ),
                               ),

But the problem is i can't specify that the selection should only include properties of a determined column. Instead the select drop down menu seems to use properties of the very first column. How can i specify the column of the 'kundeuid' property?




More information about the TYPO3-english mailing list