Overview showing tasks with due dates far in the future rather than near

[Break-Off]

Description of the issue

When there are more than 50 tasks with defined due dates in the future, Vikunja will only show the ones that are farther in the future, instead of prioritizing those nearer or overdue.

Steps to reproduce

1. Create a task with an overdue date
2. Create a task with a near due date (e.g. tomorrow)
3. Create 50 tasks with a far due date (e.g. by the end of the year)
4. Both the overdue and the near due date task will be displaced in the overview, showing only the ones farther in the future.

Expected behavior

Vikunja should prioritize showing those tasks that are either overdue or in the near future, while hiding those that are far in the future.

[kolaente]

I was able to reproduce this in a test. Looks like it is a combination of bugs in the frontend and api.

What database are you using?

[Break-Off]

Thanks for looking into the issue. I am using MariaDB, LinuxServer flavor.

[kolaente]

I've put up two PRs which should fix this:

https://kolaente.dev/vikunja/api/pulls/1177

https://kolaente.dev/vikunja/frontend/pulls/1997

I'll ping again once there's a way to test these (right now it's a bit complicated).

[kolaente]

There's a test deployment from the frontend pr now: https://1997-fix-due-soon-first--vikunja-frontend-preview.netlify.app/

Could you check if it works as intended on that test instance?

[Break-Off]

Yes, it works! Thank you for your promptness!