Skip to content

图表绑定SQL数据集,运行报错 #1171

@hui-me

Description

@hui-me
版本号:1.5.2
问题描述:图表配置SQL数据集,点击运行报错

1、SQL数据集,数据预览是有数据的
image
2、选择图表并配置该数据源
image

点击运行后出现下图错误

错误日志&截图:

/jmreport/qurestSql接口返回数据null
image

导致Console出错:
image

重现步骤:

如上。

报表SQL:
SELECT t.sDate ,t.energy_id ,t.energy_name ,t.num ,t.cost FROM (
select '2022-03' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost
union
select '2022-03' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost
union
select '2022-03' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost
union
select '2022-04' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost
union
select '2022-04' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost
union
select '2022-04' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost
union
select '2022-05' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 21.00 as num, 55.11 as cost
union
select '2022-06' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 67.00 as num, 71.00 as cost
) t
WHERE t.sDate BETWEEN DATE_FORMAT(DATE_SUB('${statisticsDate}-01', INTERVAL 11 MONTH), '%Y-%m')
AND '${statisticsDate}'

参数statisticsDate 默认上月 =dateStr('yyyy-MM', -1)
image

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

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

Activity

lvdandan16

lvdandan16 commented on Sep 2, 2022

@lvdandan16
Collaborator

收录 ws

1298191366

1298191366 commented on Oct 18, 2022

@1298191366

已修复,待新版本发布

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @1298191366@lvdandan16@hui-me

        Issue actions

          图表绑定SQL数据集,运行报错 · Issue #1171 · jeecgboot/jimureport