get SqlCommand

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

get SqlCommand

Post by harryhan » Sun Apr 18, 2021 6:02 pm

How do I get the sqlcommand of a report.

Code: Select all

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

Re: get SqlCommand

Post by Lech Kulikowski » Mon Apr 19, 2021 11:17 pm

Hello,

Your code should work.

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

Re: get SqlCommand

Post by harryhan » Tue Apr 20, 2021 7:26 am

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 903 times
Lech Kulikowski
Posts: 3592
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski » Tue Apr 20, 2021 9:44 pm

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 » Wed Apr 21, 2021 2:30 pm

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 888 times
Lech Kulikowski
Posts: 3592
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski » Thu Apr 22, 2021 12:42 pm

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 » Sun Apr 25, 2021 10:20 am

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 835 times
Lech Kulikowski
Posts: 3592
Joined: Tue Mar 20, 2018 5:34 am

Re: get SqlCommand

Post by Lech Kulikowski » Mon Apr 26, 2021 8:15 pm

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 » Mon Apr 26, 2021 8:57 pm

Sorry

the projet file is gone, here again. mea culpa

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

Re: get SqlCommand

Post by Lech Kulikowski » Thu Apr 29, 2021 10:08 am

Hello,

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

Thank you.
Post Reply