Bug #84252
closedmakeCategorizable vs. sorting
0%
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.
Updated by Benni Mack 4 months ago
- Status changed from New to Closed
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.