orgTreePC组件的里BizData设置过滤

qweasdzxc

orgTreePC组件的里BizData设置过滤
按这个代码过滤后什么都不显示了 (SA_OPOrg.sParent IS NULL)这个条件是平台固定的的吗？ 我没有写过这个过滤条件啊

jishuang

把最终的sql语句打印出来看看是什么
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

qweasdzxc

jishuang 发表于 2017-4-24 16:31
把最终的sql语句打印出来看看是什么
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=3352 ...

SA_OPOrg.sParent IS NULL 这个条件一直有

2017-04-24 16:38:57 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1) AND (SA_OPOrg.sParent IS NULL)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
  --> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.SNAME AS sName, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.sParent AS sParent, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.SZIP AS sZip, SA_OPOrg.VERSION AS version FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1]
2017-04-24 16:39:00 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1) AND (SA_OPOrg.sParent IS NULL) AND (SA_OPOrg.sFCode = '/JUSTEP/dept01' OR SA_OPOrg.sFCode LIKE '/JUSTEP/dept01/%')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
  --> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.SNAME AS sName, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.sParent AS sParent, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.SZIP AS sZip, SA_OPOrg.VERSION AS version FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) AND ( (SA_OPOrg.SFCODE = ?) OR (SA_OPOrg.SFCODE LIKE ?) ) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1, /JUSTEP/dept01, /JUSTEP/dept01/%]

jishuang

bizData上的rootFilter设置1=1

qweasdzxc

jishuang 发表于 2017-4-24 17:13
bizData上的rootFilter设置1=1

数据出来 但是树形不对啊，效果有误  刚开始是图013的样子，为什么红色部分在同一级，点了一部以后又出现图020的情况

jishuang

这个就是没设置rootFilter的问题，设置rootFilter为一部这