给你个参考,我的地区下拉树,对应三个字段
${if(len(SCMC)>0,if(len(INDEXOFARRAY(SCMC,3))>0,"AND Province = '"+ INDEXOFARRAY(SCMC,1) +"'
AND City = '"+ INDEXOFARRAY(SCMC,2) +"' AND Area = '"+ INDEXOFARRAY(SCMC,3) +"'",if(len(INDEXOFARRAY(SCMC,2))>0,"AND Province = '"+ INDEXOFARRAY(SCMC,1) +"'
AND City = '"+ INDEXOFARRAY(SCMC,2) +"' ","AND Province = '"+ INDEXOFARRAY(SCMC,1) +"'")),"")}