I can't select tables from another db schema (MS SQL) in NodeJS

[MH2ag]

Hi,

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?

Thanks for your help in advance

Marcel

[George]

Good one - we will add a schema name option to the database connection settings for MS SQL

[MH2ag]

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

[MH2ag]

Any news on this? It is still not working in NodeJS.

[George]

Just to be clear you mean you want to see the tables from other owners than dbo?

Or the tables from different databases on the same server?

[MH2ag]

@George

@George

tables from other owners than dbo?

Yes

[George]

Currently we support only public schemas.

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.

Related feature request is:

Multi Schema(PostgreSQL)

Hi, Currently the dmxDatabase.php file only looks at public schema which can be changed to show all schemas contents. But the queries generated by the framework does not include the schema name. While one can change the search_path within Postgres, this does not work if there tables with the same name across multiple schemas. <- which is the case for a project. So the question is, is there a way to use multiple schemas, or can i change something that adds the schema name to the table name whe…

So we can close this one as it is not a bug

[MH2ag]

Hi @George

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?

PHP/MS SQL

[Teodor]

This has been improved in Wappler 3.7.5
Now you can select tables from different db schemas.