能帮忙看看这个语法吗？一直提示缺少闭合符号，但是不知道在哪里加

FineReport yzmXrTpA3762457 发布于 2022-9-9 14:17

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共3回答

最佳回答

lxy2Lv6中级互助
发布于2022-9-9 14:43（编辑于 2022-9-9 14:50）

IF(B1 = "法定节假日",

IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where rote = '周内晚值班' and date_id='" + A1 + "'",1,1),

SQL("linux","select yw from DY_WORKORDER_ROTE where date_id= '"+ A1 + "' ORDER BY RAND() LIMIT 1",1,1),

IF(B1 = "工作日" || B1 = "法定调休",

IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where date_id='" + A1 + "'",1,1),

SQL("linux","select yw from DY_WORKORDER_DEPT_DICT where dept='" + B8 + "'",1,1),

SQL("linux","select yw from DY_WORKORDER_ROTE where date_id='" + A1 + "'",1,1),

IF(B1 = "内部调休",IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where date_id='" + A1 + "'",1,1),

SQL("linux","select yw from DY_WORKORDER_ROTE where date_id='" + A1 + "' ORDER BY RAND() LIMIT 1",1,1),''))))))

举报收起评论(4)

yzmXrTpA3762457(提问者) 还是缺少闭合符号

2022-09-09 14:48

lxy2 回复 yzmXrTpA3762457(提问者) 修改了

2022-09-09 14:50

yzmXrTpA3762457(提问者) 回复 lxy2 IF不符合参数类型

2022-09-09 14:52

lxy2 回复 yzmXrTpA3762457(提问者) IF(B1 = \"法定节假日\", IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where rote = \'周内晚值班\' and date_id=\'\" + A1 + \"\'\",1,1), SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id= \'\"+ A1 + \"\' ORDER BY RAND() LIMIT 1\",1,1), IF(B1 = \"工作日\" || B1 = \"法定调休\", IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\'\",1,1), SQL(\"linux\",\"select yw from DY_WORKORDER_DEPT_DICT where dept=\'\" + B8 + \"\'\",1,1), IF(B1 = \"内部调休\",IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\'\",1,1), SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\' ORDER BY RAND() LIMIT 1\",1,1),\'\'))))))

2022-09-09 15:11

Z4u3z1Lv6专家互助
发布于2022-9-9 14:18（编辑于 2022-9-9 14:33）

能复制出来么？

--------

举报收起评论(2)

yzmXrTpA3762457(提问者) IF(B1 = \"法定节假日\",IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where rote = \'周内晚值班\' and date_id=\'\" + A1 + \"\'\",1,1),SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id= \'\"+ A1 + \"\' ORDER BY RAND() LIMIT 1\",1,1)),IF(B1 = \"工作日\" || B1 = \"法定调休\",IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\'\",1,1),SQL(\"linux\",\"select yw from DY_WORKORDER_DEPT_DICT where dept=\'\" + B8 + \"\'\",1,1)),SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\'\",1,1)),IF(B1 = \"内部调休\",IF(C1 >= 18,SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\'\",1,1),SQL(\"linux\",\"select yw from DY_WORKORDER_ROTE where date_id=\'\" + A1 + \"\' ORDER BY RAND() LIMIT 1\",1,1),\'\')))

2022-09-09 14:30