search

nextcloud / tables

🍱 Nextcloud tables app
https://apps.nextcloud.com/apps/tables
GNU Affero General Public License v3.0
143 stars 24 forks source link

Broken sort by date after last upgrade #1004

Closed ostasevych closed 3 months ago

ostasevych commented 5 months ago

Steps to reproduce

  1. Have some view where the date field is present, eg Date of modification
  2. Set the rule in view to sort by date and check that it is working
  3. Upgrade to 0.7.0
  4. Open any view where sorting by date rule is present
  5. Observe that the sorting is broken
  6. Check sorting by ABC - observe that it is partially working apart of cyrillic letters Є, І, which goes at the end mistakenly

Expected behavior

The sorting by date should work as expected

Actual behavior

The sorting by date is not working at all, independently of ASC or DESC

Tables app version

0.7.0

Browser

Brave

Client operating system

Win10 x64

Operating system

Ubuntu

Web server

Apache

PHP engine version

PHP 8.2

Database

MariaDB

Additional info

I may assume that this may be related to the changes in the date format, however the Date of Modification is shown correctly.

enjeck commented 5 months ago

Hi @ostasevych. I'm unable to reproduce this. Can you please share a screencast of what's happening?

ostasevych commented 5 months ago

Hi @ostasevych. I'm unable to reproduce this. Can you please share a screencast of what's happening?

Sadly, I cannot share screencasts, please, find the screenshots where I show how ordering (sorting) is not working by the key Last changed: image image

image image

Would that be possible to make the dates shown in native normal format, eg dd.mm.yyyy?

ostasevych commented 5 months ago

The update to v.0.7.1 hasn't solved the issue :( I am still having trouble with sorting by date in views.

ostasevych commented 4 months ago

UPD: I suspect that the command occ tables:legacy:transfer:rows --all broken the data format thus the date data are no more sortable. Can anybody check that?