Page 1 of 1
Can't Query Over Tables With Schema
Posted: Sat Feb 11, 2017 6:40 am
by ipazooki
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

Re: Can't Query Over Tables With Schema
Posted: Mon Feb 13, 2017 6:39 am
by HighAley
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.
Re: Can't Query Over Tables With Schema
Posted: Wed Feb 15, 2017 10:31 am
by ipazooki
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 ?
Re: Can't Query Over Tables With Schema
Posted: Fri Feb 17, 2017 11:54 am
by Alex K.
Hello,
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
Posted: Mon Feb 27, 2017 11:20 am
by ipazooki
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 !?!
Re: Can't Query Over Tables With Schema
Posted: Mon Feb 27, 2017 9:49 pm
by Alex K.
Hello,
Please send us a request on the
support@stimulsoft.com
Thank you.