-
Notifications
You must be signed in to change notification settings - Fork 14.5k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Online报表设计,搜索条件只展示10条数据 #6857
Comments
如何使用的,截图全了 |
数据库里的工种有一百多个,但是搜索条件里只有10条。 |
你搜索就变了 |
已优化,下一版本发布。(增加滚动加载功能) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
版本号:
3.5.0
问题描述:
Online报表设计-动态报表配置明细-选择userId字段为搜索条件,使用字典code使用SQL字典查询,格式如下SELECT username AS value, realname AS text FROM sys_user,但是Popup弹窗引用时,用户信息搜索下拉框只显示10条用户数据。在sql后面拼接limit 20时出现报错提示 LIMIT 20 LIMIT ? ###
Cause: java.sql.SQLSyntaxErrorException: 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 'LIMIT 10' at line 1 ; bad SQL grammar [];
错误截图:
操作失败, ### Error querying database. Cause: java.sql.SQLSyntaxErrorException:
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
'LIMIT 10' at line 1 ### The error may exist in URL [jar:file:/E:/myMaven/Repository/org/jeecgframework/boot/hibernate-re/3.4.4-beta/hibernate-re-3.4.4-beta.jar!
/org/jeecg/modules/online/cgreport/mapper/xml/OnlCgreportHeadMapper.xml] ### The error may involve org.jeecg.modules.online.cgreport.mapper.OnlCgreportHeadMapper.
selectPageBySql-Inline ### The error occurred while setting parameters ### SQL:
SELECT group_code value, group_name text FROM saas_system.sys_group WHERE sys_group.tenant_id = 1001 LIMIT 20 LIMIT ? ###
Cause: java.sql.SQLSyntaxErrorException: 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 'LIMIT 10' at line 1 ; bad SQL grammar []; nested exception is
java.sql.SQLSyntaxErrorException: 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 'LIMIT 10' at line 1
友情提示:
The text was updated successfully, but these errors were encountered: