组织机构树

qweasdzxc

组织机构树设置像图010那样，为什么最终过滤的效果没显示，我的sql:SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg in ('1001A110000000008GBK','b41sSDHZ5Z8PJkac5xt@1001A110000000008GBK')) AND (SA_OPOrg.sValidState=1) AND (SA_OPOrg.sParent IS NULL)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1

jishuang

到数据库中执行
SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg in ('1001A110000000008GBK','b41sSDHZ5Z8PJkac5xt@1001A110000000008GBK')) AND (SA_OPOrg.sValidState=1) AND (SA_OPOrg.sParent IS NULL)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
看看能查出数据吗?

qweasdzxc

jishuang 发表于 2017-7-26 15:12
到数据库中执行
SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_ ...

多了 AND (SA_OPOrg.sParent IS NULL))

jishuang

如果不需要默认的rootFilter的过滤条件，可以在data的rootFilter上设置1=1