能正常运行出效果的校验语句:INARRAY(E6,SPLIT(SQL("JDBC1","select department02 from A_shebeifei where item='全年预算' and iyear='2016'", 1),","))=0
问题:在校验规则里面这个iyear能否使用参数名或者单元格的行列名,例如:
(1)INARRAY(E6,SPLIT(SQL("JDBC1","select department02 from A_shebeifei where item='全年预算' and iyear='${年份}'", 1),","))=0
(2)INARRAY(E6,SPLIT(SQL("JDBC1","select department02 from A_shebeifei where item='全年预算' and iyear='A4'", 1),","))=0
但是这两个校验我自己测试过都是不行的,想问一下各位大大,有没有什么办法可以在校验规则中传递一个动态的年份参数?而不是设定固定的值????
36247