预览可以正常看到数据，报表查询显示数据集配置错误11300001，Query：关键字‘where’附近有语法错误

SELECT

a.field0005 AS 修缮单单号,

a.field0012 AS 开立时间,

a.field0013 AS 希望完成时间,

a.field0019 AS 接到通知时间,

a.field0020,

b.NAME AS 检修人员,

a.field0041 AS 需求部门,

a.field0047 AS 需求区域,

a.field0006 AS 异常内容说明,

a.field0010 AS 开单人

FROM dbo.formmain_1141 a left JOIN dbo.YOA_EMPLOYEE b on a.field0020 = CAST(b.ID as nvarchar(255))

WHERE 1=1

AND finishedflag = '0'

${if(len(starttime)==0,"","where date_format(field0012,'%Y-%m-%d') >= '"+starttime+"'")}

${if(len(endtime)==0,"","and date_format(field0012,'%Y-%m-%d') <= '"+endtime+"'")}

${if(len(修缮单单号)==0,"","and field0005 = ('"+修缮单单号+"')")}