Custom Query returning error when executed in Query Builder UI

Wappler General Bugs
,
1

Wappler Version : 4.3.2
Operating System : MacOS
Server Model: NodeJS
Database Type: MSSQL
Hosting Type: NodeJS (Local Web Server)

Expected behavior

When executing a custom query in the builder UI, it should return a Query Result

Actual behavior

The query is returning an error in the Custom Query builder UI. The issue is only in the builder UI.

It’s returning the Schema correctly in builder UI and also returning data successfully when running in the SA. Code Method: SQL

How to reproduce

  1. Add a Database Custom Query in a SA
  2. Execute Query to check Schema and Query Results
  3. An error notification is generated in the custom query builder UI - Request Failed: error,
  4. When executed in the SA, it returns the data correctly

Screen Shot 2021-11-26 at 11.07.04 am
Screen Shot 2021-11-26 at 11.07.04 am697×397 16.2 KB

2

I have the same issue working with mysql and php.

3

Make sure you have your development target selected when trying to run the query

4

See:

And please stop cross posting the same issue.

5

I am working locally, I have not set a live server yet all is done on my machine locally, I have selected the target to be development and staging to test and have had no luck this has not solved the issue, sorry the multiple posts.

6

Seems your are running php so this topic doesn’t apply to you, will continue on: