Wappler Version : 4.8.2
Operating System : MacOS Big Sur - M1
Server Model: NodeJS
Database Type: Postgres
Hosting Type: Own Server
What do you think should happen?
When performing a query and returning multi reference data, I expect the query to return the related data as shown here.
What actually happens?
I have an app_user table that has multi-referenced role_assignment under it. The id field on the app_user table is of big increment type.
The role_assignment also has data in it, so it is not empty.
When I query the database to return a record, I get the following error when I make a request:
TypeError: results is not iterable\n at App._processSubQueries (.../lib/modules/dbconnector.js:279:38)
To confirm that it wasn’t just an issue with that app_user table alone. I made a new temporary user table, this time with a regular increment id (not big increment). I then added a role_assignment multi reference to the table, filled in the data and made a request, and it worked. I got the nested results.
I assume this has something to do with the way big increment IDs are parsed?