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

积木仪表盘中无法为范围查询日期赋默认值 #7967

Closed
Xgs97 opened this issue Mar 17, 2025 · 4 comments
Closed

积木仪表盘中无法为范围查询日期赋默认值 #7967

Xgs97 opened this issue Mar 17, 2025 · 4 comments
Labels
bug Something isn't working

Comments

@Xgs97
Copy link

Xgs97 commented Mar 17, 2025

版本号:

3.7.3

问题描述:

使用积木仪表盘功能添加根据日期范围查询条件,无法为其赋默认值
根据积木报表官网的方式设置时间范围不生效,只有单一查询设置生效

Image

Image

Image

错误截图:

由于没有默认值报错

Image

友情提示:

  • 未按格式要求发帖、描述过于简单的,会被直接删掉;
  • 描述问题请图文并茂,方便我们理解并快速定位问题;
  • 如果使用的不是master,请说明你使用的分支;
@Xgs97 Xgs97 added the bug Something isn't working label Mar 17, 2025
@Xgs97
Copy link
Author

Xgs97 commented Mar 17, 2025

如何使用表达式设置动态的默认时间

@Xgs97
Copy link
Author

Xgs97 commented Mar 18, 2025

暂时使用表达式处理的,麻烦回复一下正确赋值方式
<#if isNotEmpty(begin)>
AND create_time >= '${begin}'
<#else>
AND create_time >= DATE_SUB(CURDATE(), INTERVAL 6 DAY)
</#if>
<#if isNotEmpty(end)>
AND create_time < '${end}'
<#else>
AND create_time < DATE_ADD(CURDATE(), INTERVAL 1 DAY)
</#if>

@zhangdaiscott
Copy link
Member

zhangdaiscott commented Mar 23, 2025

assign sq

@jeecgDeveloper
Copy link

已修改,下版本更新

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants