Wappler Version: 3.7.6
Operating System: Big Sur 11.2.1
Having changed the database structure I
amended a simple database query.
The GUI showed the change had been made.
however, the api kept failing. On checking the
code the query had not been updated, the 'where' clause remains the same. However GUI still
shows it has been updated.
I have seen this being reported earlier too. Maybe do a deeper search on the community.
A workaround is to just create a new server action and replicate the steps one by one.
If you can post a debug log, the team might provide a better solution.
this is what I did Sid. I just wanted the developers to be aware thanks.
Also want to mention that the query in the JSON is not the actual query that is being executed on the server. What you should check is the wheres object in the JSON, that it used to build the WHERE clause on the server. We know that sometimes there are issues when the columns or tables were changed, we capture most of them but probably some still exists. The solution in that case it to rebuild the query.
rebuilding worked thanks Patrick
