View Data Doesn't Work when using Parameters
Posted: Sat Aug 14, 2021 7:59 pm
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.
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.