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

点击下拉框,并未显示待选项 #685

Closed
shenbushou opened this issue Nov 23, 2021 · 7 comments
Closed

点击下拉框,并未显示待选项 #685

shenbushou opened this issue Nov 23, 2021 · 7 comments

Comments

@shenbushou
Copy link

版本号:

1.38和1.4

问题描述:

我在两个环境,1.38和1.4中都遇到这个问题,已经设置了查询项,和查询模式,但是预览时,点击下拉框,并未显示待选项,这种情况在四个报表中有出现,其他十几个报表未发现

错误日志&截图:

image

重现步骤:

点击下拉框,并未显示 待选项
下面给出报表配置
report-export-mysql (1).txt

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

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

没显示的是用的报表参数还是报表字段

@situjunjie
Copy link

我也发现了,在同时设置有报表参数 和报表字段的查询后 报表字段的查询的下拉框就空了

@situjunjie
Copy link

1.4.0版本

@lvdandan16
Copy link
Collaborator

报表参数是必须要配置字典code,不会默认下拉框的值
你的报表参数和报表字段是同一个字段吗?

@situjunjie
Copy link

报表参数是必须要配置字典code,不会默认下拉框的值 你的报表参数和报表字段是同一个字段吗?

并不是同一个字段
SQL:
SELECT encounter_doctor_id,encounter_doctor_name,encounter_dept_name,count(encounter_doctor_name) as '门诊完成量'
from outpatient_order_db.biz_outpatient_encounter
where 1=1 and active=1 and encounter_status = '3' and encounter_type = '1' and encounter_dept_id in ('274','279','283','289','292','293','299','22060','22105','22106') and DATE_FORMAT(encounter_date,'%Y-%m-%d') between '${begintime}' and '${endtime}'
GROUP BY encounter_doctor_id,encounter_dept_id
ORDER BY encounter_dept_id,encounter_doctor_id


image
image

@lvdandan16
Copy link
Collaborator

收录 ws

@1298191366
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

4 participants