能正常运行出效果的校验语句: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 但是这两个校验我自己测试过都是不行的,想问一下各位大大,有没有什么办法可以在校验规则中传递一个动态的年份参数?而不是设定固定的值???? |
最佳回答 |
||||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|