Couch Db server action query Beta 7.23

Wappler General Need Help
1

Hi I have a simple couchdb server action query to show all items in a collection but when i click the show output on the query step i get the below error.

I have installed a new couchdb database with new collection but i get the same result. I can run the same query on the sql database with no issue different table/collection of course.

Thanks for any assistance.
I have the same setup as Brian the step that wont work for me is at 50:50 in this video.

{
"status": "500",
"message": "Cannot read properties of undefined (reading 'map')",
"stack": "TypeError: Cannot read properties of undefined (reading 'map')\n at App.select (/opt/node_app/lib/modules/dbconnector.js:48:25)\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async App._exec (/opt/node_app/lib/core/app.js:722:22)\n at async App.exec (/opt/node_app/lib/core/app.js:655:5)\n at async App.define (/opt/node_app/lib/core/app.js:637:5)"
}

2

Also tried in non beta version same issue.

The collection has 2 text fields trying to query i must be missing something simple.
Server action below

{
"meta": {
"$_GET": [
{
"type": "text",
"name": "sort"
},
{
"type": "text",
"name": "dir"
}
]
},
"exec": {
"steps": {
"name": "query",
"module": "dbconnector",
"action": "select",
"options": {
"connection": "couchdb",
"sql": {
"type": "select",
"columns": [
{
"table": "risks",
"column": "task"
},
{
"table": "risks",
"column": "control"
}
],
"table": {
"name": "risks"
},
"primary": "_id",
"joins": ,
"query": "",
"orders":
}
},
"output": true,
"meta": [
{
"type": "text",
"name": "task"
},
{
"type": "text",
"name": "control"
}
],
"outputType": "array"
}
}
}

3

I can't do any query's on the couchdb server from server action. Page flow works as normal. Can anyone point me in the right direction? all i get is the same error.

4

Ok works perfect on a new test project.. Sigh