Page 1 of 1
get SqlCommand
Posted: Sun Apr 18, 2021 6:02 pm
by harryhan
How do I get the sqlcommand of a report.
Code: Select all
report.dictionary.dataSources.list[0].sqlCommand
return undefined
Re: get SqlCommand
Posted: Mon Apr 19, 2021 11:17 pm
by Lech Kulikowski
Hello,
Your code should work.
Thank you.
Re: get SqlCommand
Posted: Tue Apr 20, 2021 7:26 am
by harryhan
Thanks.
We define the query in the report with the designer. How can we get this query per script.
Re: get SqlCommand
Posted: Tue Apr 20, 2021 9:44 pm
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.
Re: get SqlCommand
Posted: Wed Apr 21, 2021 2:30 pm
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 (111.56 KiB) Viewed 3230 times
Re: get SqlCommand
Posted: Thu Apr 22, 2021 12:42 pm
by Lech Kulikowski
Hello,
Please send us a sample project that reproduces the issue for analysis.
Thank you.
Re: get SqlCommand
Posted: Sun Apr 25, 2021 10:20 am
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.
Re: get SqlCommand
Posted: Mon Apr 26, 2021 8:15 pm
by Lech Kulikowski
Hello,
Please send us a sample project that reproduces the issue for analysis.
Thank you.
Re: get SqlCommand
Posted: Mon Apr 26, 2021 8:57 pm
by harryhan
Sorry
the projet file is gone, here again. mea culpa
Thanks
Attachment: TestSqlCommand.zip
Re: get SqlCommand
Posted: Thu Apr 29, 2021 10:08 am
by Lech Kulikowski
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.