Skip to content
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

Closed
xiaomanvip opened this issue Jul 8, 2024 · 5 comments
Closed

Online报表设计,搜索条件只展示10条数据 #6857

xiaomanvip opened this issue Jul 8, 2024 · 5 comments

Comments

@xiaomanvip
Copy link

版本号:

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

友情提示:

  • 未按格式要求发帖、描述过于简单的,会被直接删掉;
  • 描述问题请图文并茂,方便我们理解并快速定位问题;
  • 如果使用的不是master,请说明你使用的分支;
@zhangdaiscott
Copy link
Member

如何使用的,截图全了

@xiaomanvip
Copy link
Author

1001
100101
100102

@xiaomanvip
Copy link
Author

数据库里的工种有一百多个,但是搜索条件里只有10条。

@zhangdaiscott
Copy link
Member

你搜索就变了

@liaozhiyang
Copy link

已优化,下一版本发布。(增加滚动加载功能)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants