UReport2 is a high-performance pure Java report engine based on Spring architecture, where complex Chinese-style statements and reports can be prepared by iterating over cells.
SQL数据集配置中表名可以通过传参数怎么拼接呢
SELECT
d.*
FROM
tb_stock_inlayin_bound_order_detail:tenant_id d
WHERE
d.order_id = :id
tenant_id值:016904
id 值:123
涉及到的异常信息(完整异常信息):
服务端错误:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''016904' d WHERE d.order_id = '123'' at line 4
为了您的问题能得到及时准确解答,请认真填写下面各个选项,感谢您的配合。
当前使用的UReport的具体版本号:
2.2.9
遇到的问题描述:
SQL数据集配置中表名可以通过传参数怎么拼接呢 SELECT d.* FROM tb_stock_inlayin_bound_order_detail:tenant_id d WHERE d.order_id = :id
tenant_id值:016904 id 值:123
涉及到的异常信息(完整异常信息):
服务端错误:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''016904' d WHERE d.order_id = '123'' at line 4
相关截图: