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.