Microsoft SQL server query - database queries doesn't use The Database name in an sql query so it doesn't work

Wappler General Bugs
, , ,
1

When performing database actions with mssql, wapper doesn’t seem to include the database name in the query so it gives an invalid object error

example query
select * from [CodeMaster].[Currency]
output
invalid object [CodeMaster].[Currency]

when i do the same query as a custom query including the database name it works
select * from [DatabaseName].[CodeMaster].[Currency] - works

Wappler Version : 6.5.1
Operating System : windows 11
Server Model: development server nodejs
Database Type: relational database - mssql
Hosting Type: local hosting

Expected behavior

for the mssql database wappler should use the database name infront of the query
or include an option to add a prefix after the term FROM in any query