forty-two 195

Merkhilfen für mich und alle, die es interessiert

[TYPO3] Sorting of places/speakers/… in Backend – Sortierung Orte/Referenten/… im Backend

ganz einfach nur die MySQL-Anweisungen für's Sortieren in der Datei [EXT:seminars]/Configuration/TCA/tca.php wie folgt einfügen

Beispiel Zeilen ab ca. 450ff
ORIGINAL 'place' => array(
'exclude' => 0,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.place',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_sites',
'foreign_table' => 'tx_seminars_sites',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_sites'
)
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_place_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_sites'),
),
),

NEU 'place' => array(
'exclude' => 0,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.place',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_sites',
'foreign_table' => 'tx_seminars_sites',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_sites'
)
.'ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_place_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_sites'),
),
),

Und für die Zeitslots AUCH auch unten (unterhalb Zeile 2091: "$TCA[‚tx_seminars_timeslots‘] = array("
da dann als NEUE ZEILE "'foreign_table_where' => ' ORDER BY title',":

ORIGINAL 'speakers' => array(
'exclude' => 1,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_timeslots.speakers',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_timeslots_speakers_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_speakers'),
),
),

NEU 'speakers' => array(
'exclude' => 1,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_timeslots.speakers',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'foreign_table_where' => ' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_timeslots_speakers_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_speakers'),
),
),

Quelle: [TYPO3-project-seminars] Sorting of places in BE: "' ORDER BY title',"

Hinweis: Personen, wie "Professor Aaron Foobar" werden unter "P" einsortiert!

1 Kommentar

  1. Cool! Danke dir für die Hilfe, seit so langem suche ich etwas zum Thema.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht.

*

© 2017 forty-two 195

Theme von Anders NorénHoch ↑