Custom Query returning error when executed in Query Builder UI

[guptast]

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

[lsadesl]

I have the same issue working with mysql and php.

[bpj]

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

[George]

See:

Cannot do a basic query with Custom Query > Postgres 'Request Failed: error,'

You shouldn’t develop with your live server as active target. Also develop locally and when done and tested - then just deploy at once. Custom queries take a full round trip to the server to execute them. In NodeJS world this will also result in restarting the server first. So if you do that on your live server it means that it have to be uploaded, server restarted, then executed etc. Which can take a while and is not very good for running on production server. That is why we are also consider…

And please stop cross posting the same issue.

[lsadesl]

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.

[George]

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

Custom Query Request Failed: error

OS info Operating System : Windows 10.0.19042 Wappler Version : 4.4.5 Server Vagrant HashiCorp LAMP (Ubuntu build) Target selected tested: Developer, and Staging Problem description Custom queries to build a join table are not working not even adding a simple select like the one described below. The database is working if I use the simple queries actions, it just does not allow me to do any custom query always the same error Steps to reproduce Added to steps Security provider and Securi…