(ZLEVEL = 'L1' AND ${if(status == '1', "ZB_SUPER_STAT = '1'", if(status == '2', "ZB_SUPER_STAT = '2'", "ZB_SUPER_STAT <> '1'"))})
(ZLEVEL = 'L1' AND ${if(status == '1', "ZB_SUPER_STAT = '1'", if(status == '2', "ZB_SUPER_STAT = '2'", "ZB_SUPER_STAT != '1' and ZB_SUPER_STAT !='' "))})
(ZLEVEL = 'L1' AND ${if(status == '1', "ZB_SUPER_STAT = '1'", if(status == '2', "ZB_SUPER_STAT = '2'", "ZB_SUPER_STAT <> '1' and ZB_SUPER_STAT is not null"))})
不建议用空值来做状态 还是用数字吧