Query Builder is broken for pre-existing multi-step queries in 4.1.1 update

[scottclee]

Wappler Version : 4.1.1
Operating System : macOS Catalina (10.15.7)
Server Model: NodeJS
Database Type: Postgresql
Hosting Type: Custom Hosting

Expected behavior

When I select a Database Query step in an existing API action and then click on the Query Builder button I would expect the query builder to appear.

Actual behavior

Having just upgraded to the new release it now appears that if I have an API action that contains more than 1 step (one of these steps can also be a Security Provider) then the Query Builder button just freezes when I click on it.

For API actions that have a single step the query builder opens correctly.

How to reproduce

Start with a version of Wappler < 4.1.
Add an API action with multiple steps e.g. Security Provider + Query OR Query + Insert, etc.
Upgrade to Wappler 4.1.1.
Load you project and go to the Workflows view.
Click on your API action.
Then click on the Query step.
Then click on Query Builder.
The button changes colour and then nothing more happens.

I’ve just upgraded to the new release and now appears that if I have an API action that contains more than 1 step (this can also include Security Provider as one of the steps) then the Query Builder button just freezes when I click on it.

[George]

This has been reported already and a fix is available here:

Workflows - Globals - add database query, cant open query editor

Ok found the problem, it happens if you use aliases in your queries. Unpack the following dbConnector_rules.js dbConnector_rules.zip (4.5 KB) on Windows in: C:\Users\username\AppData\Roaming\Wappler\Configuration\Shared\DMXzone\dmxServerConnect\rules on Mac in: ~/Library/Application Support/Wappler/Configuration/Shared/DMXzone/dmxServerConnect/rules Make sure you place just the js file there not the whole zip! Let me know if it works It will be included with the next update

[scottclee]

Hi George, thanks for the quick response.

I’ll try the fix and report back.

[scottclee]

Note: be sure to fully replace the old file and don’t leave them alongside each other (with different names) in the directory. Otherwise the old broken code will still get picked up.

[turn3636]

I’ve tried to replace the file… But I can’t find it anywhere, either on my Mac or Windows install.

[scottclee]

I’m a Mac user and fortunately for me it was located as specified in the solution.

[turn3636]

Thanks Scott. What Mac OS do you have?

[scottclee]

Operating System : macOS Catalina (10.15.7)

[George]

This was fixed in Wappler 4.1.2