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

查询报表中日期范围和数据集求和同时存在时,查询报错,sql缺失and条件 #2258

Closed
jiakuanhu opened this issue Dec 8, 2023 · 4 comments

Comments

@jiakuanhu
Copy link

版本号:

1.6.4

问题描述:

查询报表制作,当查询报表中日期范围和数据集求和同时存在时,执行查询会报错,原因是拼接的求和sql中,缺少了and条件

错误日志&截图:

image

image
image

重现步骤:

怀疑任何一个求和+任何一个查询皆可复现 ,按照上传图片设置配置必复现。

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

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

统计函数DBSUM + 任何一个带条件查询的SQL 也有同样的问题

@lvdandan16
Copy link
Collaborator

收录 ws

@1298191366
Copy link

已修复,待新版本发布

@hechademaonini
Copy link

在1.6.6版本中依旧存在这个问题

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

6 participants