it seems Report.JS doesn't support SQL Schema !
as you can see in this picture, I have create a simple connection but Report.JS just loads my tables name without their schema , so I can't see the result unless I change the query explicitly and add schema !
generated sql code is select * from Account but it should be select * from GNR.Account
did I miss some thing
Can't Query Over Tables With Schema
Can't Query Over Tables With Schema
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Re: Can't Query Over Tables With Schema
Hello.
The Connection String should contain the Schema name.
What version of our product do you use?
Could you check our latest build? We can't reproduce the issue in it.
Thank you.
The Connection String should contain the Schema name.
What version of our product do you use?
Could you check our latest build? We can't reproduce the issue in it.
Thank you.
Re: Can't Query Over Tables With Schema
we have downloaded last version from GitHub : https://github.com/stimulsoft/Samples-J ... /AngularJS
Database is some thing like this, tables are with schema :
I create a connection like this :
I select a table, as you can see tables don't have any schema
and here generated sql code doesn't have any schema :
it should be like : Select * from GNR.Account
what's wrong with it ?
Database is some thing like this, tables are with schema :
I create a connection like this :
I select a table, as you can see tables don't have any schema
and here generated sql code doesn't have any schema :
it should be like : Select * from GNR.Account
what's wrong with it ?
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Re: Can't Query Over Tables With Schema
Hello,
Thank you for the detail description.
We need some additional time to investigate the issue.
Thank you.
Thank you for the detail description.
We need some additional time to investigate the issue.
Thank you.
Re: Can't Query Over Tables With Schema
Still no reply ? we also need to use functions like Persian that are available in Desktop version but it seems they are not available in JS version !?!
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/