Can't Query Over Tables With Schema

Stimulsoft Reports.JS discussion
Post Reply
User avatar
ipazooki
Posts: 3
Joined: Sat Feb 11, 2017 6:09 am
Location: Tehran, Iran

Can't Query Over Tables With Schema

Post 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 !

Image

generated sql code is select * from Account but it should be select * from GNR.Account

did I miss some thing :?:
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Can't Query Over Tables With Schema

Post 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.
User avatar
ipazooki
Posts: 3
Joined: Sat Feb 11, 2017 6:09 am
Location: Tehran, Iran

Re: Can't Query Over Tables With Schema

Post 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 :
Image

I create a connection like this :
Image

I select a table, as you can see tables don't have any schema
Image

and here generated sql code doesn't have any schema :
Image

it should be like : Select * from GNR.Account

what's wrong with it ?
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Can't Query Over Tables With Schema

Post by Alex K. »

Hello,

Thank you for the detail description.
We need some additional time to investigate the issue.

Thank you.
User avatar
ipazooki
Posts: 3
Joined: Sat Feb 11, 2017 6:09 am
Location: Tehran, Iran

Re: Can't Query Over Tables With Schema

Post 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 !?!
Your Truly,
Mohammad Reza Pazooki | Web Developer | http://www.nomatec.net/
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Can't Query Over Tables With Schema

Post by Alex K. »

Hello,

Please send us a request on the support@stimulsoft.com

Thank you.
Post Reply