#41346Storing foreign_sortby fields for IRRE 1:n comma-separated values
Description
When setting up an 1:n relation in IRRE without a foreign_field, that is a relation stored as a comma-separated list of values, foreign_sortby does not get updated on TYPO3 4.7.4. It is still used in a couple of queries (e.g. my Extbase model returns objects according to ORDER BY sorting).
This behavior is somewhat inconsistent and unexpected. Also, I couldn’t find any info that this combination shouldn’t work. To improve the situation a bit I patched my copy of t3lib/class.t3lib_tcemain.php (see attached patch). This works for me (the values are getting “sorting” values of 0, 1, …), but is probably somewhat hackish.
I think this should be addressed or at least documented even if this relation type might be somewhat frowned upon.