Bug #16796
closed
list module doesn't sort correcly by date
0%
Description
if i create 10 tt_news records in a custom WS, and then i change their date , when i sort by date in the lsit module, it doesn't work well..
even in the FE (preview mode) the "sort by date" of the tt_news doesn't work well.
i don't know if this is a WS or a tt_news problem
(issue imported from #M4671)
Updated by Martin Kutschker almost 18 years ago
DB-based sorting won't work within a WS. The code will get all records (sorted) from the LIVE WS. After that the versinonig will be allpied by PHP, but no resorting will occur.
Maybe it can be solved by a proper OUTER JOIN with the (news) table itself. The idea is to do the sorting to use an IF or IFNULL on the sort fields. The IF/IFNULL tests if a version has been found and returns either the WS version or the base/LIVE version. The only thing is that you cannot use an index with such an SQL statement.
Question: where to create the SQL statement? Shall any existing (plugin) API build it automatically? How?
Updated by Tolleiv Nietsch almost 13 years ago
- Category deleted (
Miscellaneous) - Status changed from New to Closed
- Target version deleted (
0)
The mentioned bug is a known and well documented limitation of the concepts we're based on. I close the issue because I don't expect any changes in the v4 branch for this and to regain a clean bugtracker.
Updated by Michael Stucki almost 11 years ago
- Project changed from 624 to TYPO3 Core
- Category changed from Workspaces to Workspaces