Database sort in Capacitor SQLite within flow not working

kfawcett · January 18, 2024, 11:15pm

Wappler Version: 6.0.5 Stable
Operating System: Windows 11
Server Model: Capacitor
Database Type: SQLite
Hosting Type:

Expected behavior

When setting a sort in query builder for capacitor sqlite, the resulting records should be sorted.

Actual behavior

Records are not sorted.

How to reproduce

Create a database query within an App Flow or Page Flow with a sort.

franse · January 18, 2024, 11:28pm

What version of SQLite is? You can see it on package.json

kfawcett · January 18, 2024, 11:43pm

5.5.0

franse · January 18, 2024, 11:56pm

Well, I don’t know if it’s related, but I can see you use the sql.js 1.9.0 which has some troubles.
Maybe you can revert to 1.8.0 which is on the last version of Wappler until (I guess) the sqlite team fix the bug.

Because is an active project, maybe you can try the workaround (I don’t know if 1.8.0 will fix this)

Make a backup
Pin sql.js to 1.8.0 (without the ^)
Run npm install
Copy the wasm file (node_modules/sql.js/dist/sql-wasm.wasm) to the assets folder

kfawcett · January 19, 2024, 12:35am

Thanks Franse, I tested your solution, but I don’t think that’s the issue. I believe sql.js is only used in combination with jeep-sqlite when attempting to run the app in a browser. I’m running in Electron, so I don’t think it’s used.

franse · January 19, 2024, 12:52am

Just tested with 1.8.0 and not working on page flow, but the query does:

So I think is related to the flow and not to SQLite

I also tried the data view component and not working:

As a workaround you can use the sort property on the binding panel.

flow1.data.query.sort(`email`)

For some reason, flow1.data.query.sort(`email`).reverse() (for desc) doesn’t work on UI

But go to the code and add it:
<tbody is="dmx-repeat" dmx-generator="bs5table" dmx-bind:repeat="flow1.data.query.sort(`email`).reverse()" id="tableRepeat2">

franse · January 19, 2024, 1:13am

Another workaround:

Converting to “custom” will work

kfawcett · January 19, 2024, 1:24am

Nice! Glad you were able to confirm. I tried a data view as well and had the same issue. I’ll try a custom query.

kfawcett · January 19, 2024, 2:51am

Converting to a custom query worked for me! Thanks again for the workaround @franse.

patrick · January 22, 2024, 1:33pm

Here an update: dmxCapacitorSQLite.zip (10.1 KB)

kfawcett · January 22, 2024, 2:18pm

Thanks @patrick! That resolved sorting.

Teodor · January 26, 2024, 7:23am

Fixed in Wappler 6.1.2