其他配置相同,定时调度-调度周期-公式判断是否不同版本有字数限制, 这样写SQL公式是可以保存的 SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24' ",1,1) <> null 加了条件后就保存不了了 SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24'and T1.ShortName = '1' or T1.ShortName = '2' ",1,1) <> null 但是用我本地的又可以保存 SQL("dm","SELECT T1.ShortName FROM (select * from dm.FIN_Material_Price_Rise) AS T1 INNER JOIN dw.Input_RawMaterial_Standard AS T2 ON 1=1 where t1.Marketdate = '2022-08-24'and T1.ShortName = '1' or T1.ShortName = '2' ",1,1) <> null 版本截图,失败版本直接下载软件,之后从低版本跨版本升级的 成功版本截图,直接下载的软件 |