Displayed articles are not sorted by date

[gsantner]

IMPORTANT

• I have read the CONTRIBUTING.md and followed the provided tips
• I accept that the issue will be closed without comment if I do not check here
• I accept that the issue will be closed without comment if I do not fill out all items in the issue template.

Explain the Problem

Articles shown in the frontend are not sorted by it's date, but instead of some import date / import ID and grouping.

Please see the video below, you can clearly see that there are articles once "x hours ago", then "days ago", then "hours ago" again, then somewhen "weeks ago"...
I do expect that WHATEVER the source of the news article is, is on top if it was published the most recently.

cut.mp4

This issue seems similar but was closed and stayed closed: #51

What I quickly tried is changing the OrderBy at nextcloud/apps/news/lib/Db/ItemMapperV2.php to pub_date, then the situation minimally improved, but guess thats the point where changes are needed.

Just for reference, this is how TT-RSS orders newest:

Steps to Reproduce

Explain what you did to encounter the issue

1. Open news
2. see the list is not ordered by date and I have to read OLD news first, before seeing other NEW news. Inverse - have to read NEW news, before seeing other OLD news of it!

System Information

• News app version: 17.0.0
• Nextcloud version: 22.2.3
• Cron type: crontab
• PHP version: 7.4
• Database and version: mariadb 10
• Browser and version: Any browser
• OS and version: Any OS with a browser

---

Would be really cool if you can sort the news by date, instead of some ID made up on your own at database. It would be very fine if the user needs to check "sort by date" / toggle between ID and date, whatever is easiest and works
Thanks!

[Grotax]

I think this needs to be handled by the client, for the api this should not matter.
Sorting is something for the human and preferences might be different.

So in the case of the old webapp the javascript would need to sort the items according to the users preference.

[gsantner]

Agree that its a client thing, however in this project the web Frontend/"client" seems quite though coupled to the backend. like database queries on it's own. correct?

And yes, a user setting is OK and welcome.... whatever allpws to sort properly by date instead of some articleid and feed grouping.

[Grotax]

Yea that's true, so far nobody managed to modernize the webapp, if it happens one day I think this should be part of that.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[chylex]

Seems editing nextcloud/custom_apps/news/lib/Db/ItemMapperV2.php does not work anymore, still getting wrong order when viewing a folder:

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[chylex]

The issue is still relevant.

[Grotax]

Yea but I think it can be closed, the frontend urgently needs a complete rewrite as the technology it uses is no longer supported and bugs/security issues will stay open. If that is not done the problem will keep existing for forever.
If the frontend gets rebuild this issue will not be relevant anymore.

[Grotax]

Related to #195

[fazlerabbi37]

@Grotax maybe we can add this as todo/sub task for #195? This way it's not 'out of sight'.

[Grotax]

You could write a comment there, but I fear it won't change much.

The frontend based on the original angular js, that is no longer supported.

The frontend needs to be rebuild with a new JavaScript framework, Vue js makes sense since Nextcloud provides common components for that and most internally (by the company) maintained apps use Vue now or soon.

There were attempts to do that but it's not that easy to do and currently there is again no ongoing progress.

[alesha1488]

please, fix this bug.