Unable to filter data in SQLite (capacitor mobile project)

Mobile Apps Bugs
1

Wappler 7.7.5 macOS 15.7.4

Hello everyone,

In my capacitor mobile project, I’m using SQLite to store local data. When I’ve added Conditions filter in the query, It’s output is blank. If I remove the Conditions, everything works fine. Same issue occurs when Sorting is used. Am I doing anything wrong or it’s a bug, Please check.

image
image788×311 15 KB

<script is="dmx-flow" id="flowAllEmpList" type="text/dmx-flow" src="/app/flows/employees/allEmployees.json" autorun="true" dmx-param:filter="f7ptrSyncEmp.filter.value||''"></script>

image
image294×340 19.3 KB

2

Are you entirely sure this is the correct expression?
I suggest you create a var linked to that value and check the result on console with dmx.app.data

image
image539×214 8 KB

<script is="dmx-flow" id="testflow" type="text/dmx-flow" src="app/flows/test.json" autorun="true" dmx-param:filter="123"></script>

image
image517×314 13 KB

4

@patrick this bug is surely related to dmxCapacitorSQLite.js can you please have a look into this. I tried to fix this using Claude Opus 4.6. It did some changes in this file and it’s fixed but there is another issue caused so I reverted back.