How do I get the search function to work in offline mode?

I am struggling to get the search function to work when in offline mode.
I have cached the query, and the data shows in the list when offline but when I try to search through that data it does not filter.

This is the query:

Select * FROM "EVM_Address_Test"
WHERE address ilike {{'%' + SearchAddress.value + '%'}}

I assume it won't search the query as it can't while offline, how do I over come this?



Have you look into Query JSON with SQL?

Once you convert your SQL's results into JSON format (formatDataAsArray), you can use SQL syntax to filter results. The key feature about this is Query JSON with SQL is essentially JavaScript library so it runs in browser without rerun in SQL server to filter data.