File collection : allow multiple category selection
It's currently not possible to create a file collection with multiple category selection.
#3 Updated by Andrea Herzog-Kienast over 4 years ago
- Assignee set to Frans Saris
Create a parent category "City".
Create some childs "Wien", "Dresden", "Buildings".
Create another parent "TYPO3" without children.
It is not possible to chose more than one category - not another parent and no childs.
It would also be great to chose a folder and categories, what even is not possible.
For me, it's a must have :).
#6 Updated by martijn no-lastname-given almost 3 years ago
The problem here starts with the Table design as far as I can tell. The Table "sys_file_collection" has a field "category" which would restrict this relations to category to a "1:1" relation.
In order to resolve this issue, it would be necesarry to change the table, remove the "category" column, create a table similar to "sys_category_record_mm" and store the "filecollection - category" relationship in a "many-to-many" fashion there.
My Question, if im correct, are as follows:
- If I'd fix this in typo3 v7 LTS - will these changes merge into 8 LTS?
#9 Updated by Oliver Hader over 2 years ago
Just to be sure: This issue is about table sys_file_collection, correct? The field category is defined a 1:1 assignment to sys_category (be aware that this is a field for querying results, not to define categories for a file collection). Using an MM approach does not seem to fit here - in no way the relations shall be stored in the existing sys_category_record_mm table - having a simple list of category UIDs seems to be fine here. These can be use to run a subquery against existing relations to determine the result-set.
If it's going to be a list of UIDs, no further upgrade wizard have to be implemented since the current definition is a "list" as well, with just only one item...