get SqlCommand

[harryhan]

How do I get the sqlcommand of a report.

Code: Select all

report.dictionary.dataSources.list[0].sqlCommand

return undefined

[Lech Kulikowski]

Hello,

Your code should work.

Thank you.

[harryhan]

Thanks.

We define the query in the report with the designer. How can we get this query per script.

[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]

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 888 times

[Lech Kulikowski]

Hello,

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

Thank you.

[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.

[Lech Kulikowski]

Hello,

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

Thank you.

[harryhan]

Sorry

the projet file is gone, here again. mea culpa

Thanks
Attachment: TestSqlCommand.zip

[Lech Kulikowski]

Hello,

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

Thank you.