DB Multiple Records Query NOT showing as an array in AC - limiting the available options in UI

Wappler Version : 3.7.3
Operating System : Mac
Server Model: NodeJS
Database Type: MySql8
Hosting Type: AWS/DOCKER.

Expected behavior

I create a Server Action which includes a Database Multiple Records Query. I expect to be able to select this as an array so that I can use the various options in AC such as count/sum etc. that relate to choosing an array. Instead I get a simple ‘A’ indicating a value only, so I have to write everything manually.

Actual behavior

As above.

Noting this has happened to me on a consistent basis over the last few weeks, I’ve just not raised this as I just manually resolve it by typing in the code.

This happens mostly when using conditions in the DB Query, however I have noticed it happening even with a very simple multi record query with no conditions.

Here is an image of the SC on the AC side:

Screen Shot 2021-02-02 at 9.26.27 am

When I use the Dynamic Picker:
Screen Shot 2021-02-02 at 9.27.00 am

This should be an array, instead it’s just ‘A’ indicating ‘text value’.

Team - please let me know if you need any other information.

Community Page
Last updated: