View doesn't exist error editing query that uses a table View - views not showing in Query Builder dropdown

Wappler Version : 3.7.8
Operating System : Mac 10.15.6 (Catalina)
Server Model: PHP
Database Type: MySQL
Hosting Type: Custom

Expected behavior

Edit or Create a query that uses a table View by creating a database query and then click on “Query Options” and choose a View from the dropdown.

Actual behavior

For an existing query that uses a View I get the following error and none of my Views show up in the dropdown. If I try to create a new query they don’t show up in that dropdown either.

How to reproduce

Try to create a query using a View instead of table or edit an existing query that uses a View

Anyone else experiencing this bug? I guess for now I can manually edit the api file. :neutral_face:

Ok it appears that refreshing the connection worked and the views are now seen. Whew