Issue Bug Closed

#84252makeCategorizable vs. sorting

SICOR KDL GmbH 03/14/18, 08:30 updated 08/06/24, 14:53

Description

Hello,

we’re using makeCategorizable for one of our tables and want its records to be sorted by title. The problem is that the entire attribute ‘foreign_table_where’ has to be set then, since it already has an ORDER BY sys_category.sorting appended. Now:

Idea1 (straight from the manual):
foreign_table_where = ‘ AND sys_category.sys_language_uid IN (-1, 0) ORDER BY sys_category.title’;

Problem: This doesn’t work in environments with multiple language category trees.

Idea2:
foreign_table_where = ‘ AND sys_category.sys_language_uid=###REC_FIELD_sys_language_uid### ORDER BY sys_category.title’;

Problem: This doesn’t work in environments with category trees that have sys_language_uid = -1.

Basically I think one should be able to just set the desired ORDER BY and leave the entire language handling to the framework.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

History 1

  1. Benni Mack commented and changed status New Closed 08/06/24, 14:53

    Hey,

    sorry for the long delay. In TYPO3 v11 we introduced type=category in order to overcome various issues related to sys_category. So it should now be possible to extend this with foreign_table_where in type=category.

    If you still have issues, let me know, and I will reopen this ticket.

    All the best,
    Benni.