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

查询条件下拉框只显示10条数据 和 下拉框模糊查询显示问题 #766

Closed
yueyunp opened this issue Jan 12, 2022 · 3 comments

Comments

@yueyunp
Copy link

yueyunp commented Jan 12, 2022

版本号:
    <dependency>
        <groupId>org.jeecgframework.jimureport</groupId>
        <artifactId>jimureport-spring-boot-starter</artifactId>
        <version>1.4.2</version>
    </dependency>
问题描述:

报表查询只显示10条数据 按配置文件配置了也是10条 发现后台日志查询时 一直有 limit 10 的条件
2022-01-12 10:40:36.799 [http-nio-28298-exec-10] INFO org.jeecgframework.minidao.aop.MiniDaoHandler- page countsql===> SELECT count(0) FROM (SELECT DISTINCT dict.text, dict.value FROM (SELECT component_name AS text, component_name AS value FROM snr_competence_center.snr_cpt_component WHERE delete_token = '1') dict) table_count
2022-01-12 10:40:36.809 [http-nio-28298-exec-10] INFO org.jeecgframework.minidao.aop.MiniDaoHandler- page executeSql===> SELECT distinct dict.text,dict.value FROM (SELECT component_name as text,component_name as value FROM snr_competence_center.snr_cpt_component WHERE delete_token = '1') dict
LIMIT 10

错误日志&截图:

这是我的配置文件
image
我是通过字典直接查数据库的当条件的如下:
image
查询的sql是很基础的如下:
SELECT component_name as text,component_name as value FROM snr_competence_center.snr_cpt_component WHERE delete_token = '1'
预览时下拉框只有10条:

重现步骤:

友情提示(为了提高issue处理效率):

  • 积木报表是一款免费报表产品,功能免费源码不开放;
  • 未按格式要求发帖,会被直接删掉;
  • 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
  • 针对不好重现的问题,请录制操作视频或详细的重现步骤;
@yueyunp
Copy link
Author

yueyunp commented Jan 12, 2022

预览的效果图
image

@yueyunp
Copy link
Author

yueyunp commented Jan 12, 2022

下拉框模糊查询显示问题
连续2次搜同一个汉字时 第二次之后就不显示了

注意搜索的这个项目是这个下拉框展示的10条之外的(他只展示10条 但是他可以搜索10条之外未展示的)
比如 1.我输入 0 下拉框会出现我要搜的 这时候我不选中 我点页面空白位置 让下拉框自动闭合
image
2.再次输入0 时下拉框就搜不到了
image

@1298191366
Copy link

下拉框模糊查询显示问题,已修复,待新版本发布

查询条件下拉框只显示10条数据,在1.4.21之后的版本采用参数配置的形式 文档地址:http://report.jeecg.com/2373407
image
升级到1.4.21

<dependency>
    <groupId>org.jeecgframework.jimureport</groupId>
    <artifactId>jimureport-spring-boot-starter</artifactId>
    <version>1.4.21</version>
</dependency>

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