get SqlCommand

Stimulsoft Reports.JS discussion
Post Reply
harryhan
Posts: 5
Joined: Sun Apr 18, 2021 10:56 am

get SqlCommand

Post by harryhan »

How do I get the sqlcommand of a report.

Code: Select all

report.dictionary.dataSources.list[0].sqlCommand
return undefined
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski »

Hello,

Your code should work.

Thank you.
Attachments
Screenshot 2021-04-20 011644.png
Screenshot 2021-04-20 011644.png (245.33 KiB) Viewed 3100 times
harryhan
Posts: 5
Joined: Sun Apr 18, 2021 10:56 am

Re: get SqlCommand

Post by harryhan »

Thanks.

We define the query in the report with the designer. How can we get this query per script.
Attachments
Screenshot 2021-04-20 092329.png
Screenshot 2021-04-20 092329.png (29.27 KiB) Viewed 3095 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski »

Hello,

With the following code:
report.dictionary.dataSources.list[0].sqlCommand

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.
harryhan
Posts: 5
Joined: Sun Apr 18, 2021 10:56 am

Re: get SqlCommand

Post by harryhan »

hello

the sql command from the report is required.
i can't find my error.
thank you
harry

Screenshot 2021-04-21 162556.png
Screenshot 2021-04-21 162556.png (111.56 KiB) Viewed 3080 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski »

Hello,

Please send us a sample project that reproduces the issue for analysis.

Thank you.
harryhan
Posts: 5
Joined: Sun Apr 18, 2021 10:56 am

Re: get SqlCommand

Post by harryhan »

Hello

we test the problem with the example project on your Githup page: https://github.com/stimulsoft/Samples-J ... t%20viewer
and change the ngOnInit code
here too, the same problem.
Attachments
Screenshot 2021-04-25 121656.png
Screenshot 2021-04-25 121656.png (89.25 KiB) Viewed 3027 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski »

Hello,

Please send us a sample project that reproduces the issue for analysis.

Thank you.
harryhan
Posts: 5
Joined: Sun Apr 18, 2021 10:56 am

Re: get SqlCommand

Post by harryhan »

Sorry

the projet file is gone, here again. mea culpa

Thanks
Attachment: TestSqlCommand.zip
Attachments
TestSQLCommand.zip
(150.39 KiB) Downloaded 136 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
Post Reply