Project

General

Profile

Actions

Bug #84252

closed

makeCategorizable vs. sorting

Added by SICOR KDL GmbH over 6 years ago. Updated 4 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Backend API
Target version:
-
Start date:
2018-03-14
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

Actions #1

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.

Actions

Also available in: Atom PDF