[TYPO3-dev] Sorting of fe_groups

[Michael Miousse]

Le Mon, 06 Jul 2009 12:52:54 +0000, Michael Miousse a écrit :

> Le Mon, 06 Jul 2009 12:07:54 +0200, Steffen Gebert a écrit :
> 
>> Hi devs,
>> 
>> I'm trying to sort the select field for fe_groups in Access tabs of
>> pages/content elements.
>> 
>> I already tried this in extTables.php, without effect:
>> t3lib_div::loadTCA('fe_groups');
>> $TCA['fe_groups']['ctrl']['sortby'] = 'title';
>> $TCA['fe_groups']['ctrl']['default_sortby'] = 'ORDER BY title';
>> 
>> Where can I change order? IMHO these fields should be sorted
>> alphabetically by default (so if you could tell me, where it's defined,
>> I'll provide an RFC - if you aren't against this improvement).
>> 
>> Regards
>> Steffen
> 
> hi Steffen
> 
> If i get it right, you want to change the order in the acces group field
> from the tt_content TCA.
> 
> If so you need to  change the TCA for tt_content, not for fe_groups.
> 
> You will have to add a foreign_table_where like this:
> 
> $TCA['tt_content']['columns']['fe_group']['config']
> ['foreign_table_where'] => 'ORDER BY fe_users.title',
> 
> Regards
> 
> Miousse

By the way, it is the same trick for pages