PouchDB View unable to sort on date data

Wappler General Need Help
1

Wappler Version: Wappler 6 Beta 15
Operating System: Windows 11
Server Model: Capacitor
Database Type: Pouch/Sqlite
Hosting Type: N/A

Expected behavior

Sorting on a Date field should sort records correctly.

Actual behavior

Records do not appear to follow the date sort

image
image233×621 8.94 KB

How to reproduce

  1. Setup Pouch with a database table that has a Datetime field
    image
  2. Add records with a date field
    image
  3. Add a PouchDB View to page and attempt to sort on the date field
    image
2

As the date is formatted display date, you might want to convert it to something else so it can be sortable. Like a timestamp or iso date

3

There’s no expression editor on the sorton property. Will it work if I hand code it? Or are you saying I should modify it in the database when it’s inserted?