数据集一直加载不出来，是sql写的问题吗，预览的话很慢，但会出来这个就一直出不来

FineReport 梦溪 发布于 2020-5-3 09:09

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

snrtuemcLv8专家互助
发布于2020-5-3 10:17

你的sql有问题，发出来看下

举报收起评论(4)

梦溪(提问者) select c.ranknumber, (case when left(CONVERT(VARCHAR,a.createtime,108),2)>=09 and left(CONVERT(VARCHAR,a.createtime,108),2)<17 then \'午餐\' when left(CONVERT(VARCHAR,a.createtime,108),2)>=17 and left(CONVERT(VARCHAR,a.createtime,108),2)<22 then \'晚餐\' when left(CONVERT(VARCHAR,a.createtime,108),2)>=22 or left(CONVERT(VARCHAR,a.createtime,108),2)<09 then \'夜餐\' end ) shiduan , sum(goodsnumber*goodspriceoriginal) zong from WaiterOrder a,WaiterOrderDetail b,( SELECT orderid,RankNumber from JK_PayOrder where CustomerID in ( select CustomerID from JK_Customer where Phone!=\'\' and WXOpenID like \'oj%\' ) and ordertype=\'1\' and orderid!=\'999\' --and CreateTime >\'2020-05-01\' ${IF(SDATES == \'All\' || len(SDATES)==0,\"\",\" AND CreateTime >=\'\" +SDATES+ \"\'\")} ${IF(EDATES == \'All\' || len(EDATES)==0,\"\",\" AND CreateTime <=\'\" +EDATES+ \"\'\")} UNION select WaiterOrderid,RankNumber from JK_MemberCardRecord where recordtype=\'0\' and WaiterOrderid>\'999\' --and CreateTime >\'2020-05-01\' ${IF(SDATES == \'All\' || len(SDATES)==0,\"\",\" AND CreateTime >=\'\" +SDATES+ \"\'\")} ${IF(EDATES == \'All\' || len(EDATES)==0,\"\",\" AND CreateTime <=\'\" +EDATES+ \"\'\")} and CustomerID in ( select CustomerID from JK_Customer where Phone!=\'\' and WXOpenID like \'oj%\' )) c where a.WaiterOrderid=c.orderid and b.WaiterOrderid=c.orderid GROUP BY c.ranknumber,(case when left(CONVERT(VARCHAR,a.createtime,108),2)>=09 and left(CONVERT(VARCHAR,a.createtime,108),2)<17 then \'午餐\' when left(CONVERT(VARCHAR,a.createtime,108),2)>=17 and left(CONVERT(VARCHAR,a.createtime,108),2)<22 then \'晚餐\' when left(CONVERT(VARCHAR,a.createtime,108),2)>=22 or left(CONVERT(VARCHAR,a.createtime,108),2)<09 then \'夜餐\' end )

2020-05-03 11:23