单选的时候没有问题,但是多选的时候,就出不来数据,分隔符都已经设置好了,不知道是不是代码有问题${IF(LEN(BUMENID)==0,"","AND A.ADMINIDTREE IN (SELECT DISTINCT T.ADMINIDTREE FROM DIM_ADMIN T WHERE DATAFROM='OA'--OA部门 AND ISCOMPANY='0'--部门 AND ISCANCELED = '0'--未取消 AND COMPANYID IN ('181', '381') START WITH T.ADMINID IN ('"+BUMENID+"') CONNECT BY T.FADMINID=PRIOR T.ADMINID AND ISCANCELED = '0')")},跪求大神 |