Server Connect not being saved and becomes unresponsive to clicks when setting an ALIAS to get the max_value

[t11]

Wappler Version : 4.1.1
Operating System : Windows 10
Server Model: PHP
Database Type: MySql
Hosting Type: LAMP

Expected behavior

What do you think should happen?

Trying to get the max value as indicated here How to get max value from one table and use it to insert into another table?

Actual behavior

What actually happens?

Creating the query but it does not actually saves it. I mean when I reproduce the indicated steps to get the max value, the ServerConnect action can not be saved. The server action was already created with some other actions in it. Just wanting to get the max value and insert it to another table. The issue only happens when trying to set the ALIAS. Without setting the ALIAS, the ServerConnect action is being saved.

How to reproduce

Try to get the MAX value from a query and set an ALIAS for it.

[Sorry_Duh]

Maybe related to this?

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

With the alias click issue if you haven’t yet seen this

[t11]

Thank you @Sorry_Duh, but unfortunatelly it did not work. Still having the same issue when using an ALIAS. Problem solved by creating a custom query.

Thanks you!

[George]

This was fixed in Wappler 4.1.2