Page 1 of 1

View Data Doesn't Work when using Parameters

Posted: Sat Aug 14, 2021 7:59 pm
by AcidSlide
Hi,

We are having issues with the current 2021.3.6 version for the ReportJS. When dealing with SQL based datasource (MySQL and MSSQL), the View Data doesn't work when the SQL uses parameters;

For example:

This works View Data returns a data:
select * from `shipment_cost` where ReferenceNbr='REF00012345'

But this doesn't work (no data is returned in View Data):
select * from `shipment_cost` where ReferenceNbr='{ReferenceNbr}'


After further investigation we noticed the the Report Designer is sending this queryString: {"command":"ExecuteQuery","connectionString":"","queryString":"select * from `shipment_cost` where ReferenceNbr=''"} (blank even if we input a data in the popup screen requesting the ReferenceNbr value)

We know this used to work with previous versions of ReportJS (we think prior to 2021.3.x verson).

I hope you can help us out.

Re: View Data Doesn't Work when using Parameters

Posted: Tue Aug 17, 2021 7:03 am
by Lech Kulikowski
Hello,

Thank you for the bug report. We need some time to fix the issue.

Thank you.
#4698

Re: View Data Doesn't Work when using Parameters

Posted: Tue Aug 17, 2021 8:52 am
by AcidSlide
thanks for the response.. we hope this can be resolved as soon as possible as this really helps in testing for valid data from the queries..

thanks again
Lech Kulikowski wrote: Tue Aug 17, 2021 7:03 am Hello,

Thank you for the bug report. We need some time to fix the issue.

Thank you.
#4698

Re: View Data Doesn't Work when using Parameters

Posted: Wed Aug 18, 2021 7:50 pm
by Lech Kulikowski
Hello,

We will let you know about the result.

Thank you.

Re: View Data Doesn't Work when using Parameters

Posted: Wed Sep 15, 2021 12:25 pm
by AcidSlide
Hello,

Any updated regarding this?

Thanks

Re: View Data Doesn't Work when using Parameters

Posted: Thu Sep 16, 2021 1:36 pm
by Lech Kulikowski
Hello,

We are still working on the problem. We will let you know when the solution is available.

Thank you.