as I wrote in the title I can’t select tables from another db schema anymore. I recreated my API in NodeJS and created new database connections with the new db manager. My new connection to our MS SQL server only connects to the standard dbo schema.
The “old” db connection prior Wappler 3.0 was able to read additional schemas.
Any idea how i can solve this?
Hi @George, thank you for adding the db schema for selecting tables in queries.
Is it also planned to have the functionality in db manager? I only see the tables from the dbo schema (MS SQL) in db manager.
EDIT: I only tested in PHP. Selecting tables from another schema is still not working in NodeJS. At the moment I have a workaround with custom queries with copy & paste from Navicat, but it would be great if it could be changed after your vacation
Having multiple schema support is really much more complex - as we have to change all our query builders to allow to first pick the schema picking before getting the tables. While usually you always have a single schema.
I understand that it would be quite complex to change the query builders.
For me it would be enough to just see the tables to be able to create a simple query.
This is already possible in PHP with MS SQL. I just would like to have the same function in NodeJS. Would this be possible?