Wappler Version : 6.0.1
Operating System : Windows 11 22H3
Server Model: NodeJS
Database Type: PostgreSQL
Hosting Type: Docker
I have a “simple” SQL query bellow which runs just fine.
{{availableDates}} is array of dates.
But when I’m switching to Custom and just click OK and Saving - This query brakes.
Result of switching to Custom:
SELECT parkingSlots.id, parkingSlots.name, parkingSlots.notes, parkingSlots.floor
FROM parkingSlots
RIGHT JOIN bookings AS active_bookings ON active_bookings.parkingSlot = parkingSlots.id
WHERE active_bookings.date IN ({{availableDates}})
And error message:
{
"status": "500",
"code": "42P01",
"message": "SELECT parkingSlots.id, parkingSlots.name, parkingSlots.notes, parkingSlots.floor\nFROM parkingSlots\nRIGHT JOIN bookings AS active_bookings ON active_bookings.parkingSlot = parkingSlots.id\nWHERE active_bookings.date IN (2023-12-07,2023-12-08,2023-12-09,2023-12-10) - relation \"parkingslots\" does not exist",
"stack": "error: SELECT parkingSlots.id, parkingSlots.name, parkingSlots.notes, parkingSlots.floor\nFROM parkingSlots\nRIGHT JOIN bookings AS active_bookings ON active_bookings.parkingSlot = parkingSlots.id\nWHERE active_bookings.date IN (2023-12-07,2023-12-08,2023-12-09,2023-12-10) - relation \"parkingslots\" does not exist\n at Parser.parseErrorMessage (/opt/node_app/node_modules/pg-protocol/dist/parser.js:287:98)\n at Parser.handlePacket (/opt/node_app/node_modules/pg-protocol/dist/parser.js:126:29)\n at Parser.parse (/opt/node_app/node_modules/pg-protocol/dist/parser.js:39:38)\n at Socket.<anonymous> (/opt/node_app/node_modules/pg-protocol/dist/index.js:11:42)\n at Socket.emit (node:events:517:28)\n at addChunk (node:internal/streams/readable:368:12)\n at readableAddChunk (node:internal/streams/readable:341:9)\n at Readable.push (node:internal/streams/readable:278:10)\n at TCP.onStreamRead (node:internal/stream_base_commons:190:23)"
}