setfilter无法过滤指定部门（selectorgpc组件）

lwcompany

Model.prototype.orgSelectPC1ShowOption = function(event){
           debugger;
              var SA_OPOrg=this.comp("bizData1");
               var like="LIKE '%/集团/总经理室/零售部%'";
                    SA_OPOrg.setFilter("sFName","SA_OPOrg.sFName='"+like+"'");
           debugger;

又试了
var SA_OPOrg=this.comp("bizData1");
               var like="集团/总经理室/零售部";
                   SA_OPOrg.filters.setFilter("sFName","SA_OPOrg.sFName LIKE '%"+like+"%'");
                    SA_OPOrg.refreshData();
还是不好用
无法过滤出指定部门，事件触发后只能显示顶层菜单

jishuang

如果是根目录的过滤参考
http://docs.wex5.com/bex5-ui-question-list-10084/

lwcompany

我的组件是orgselectpc，没有这个属性呀，我想过滤中间结点

jishuang

只要是data设置的树形的都可以设置设置

orgSelectPC里面默认封装了树形的data

lwcompany

   SA_OPOrg.getTreeOption().rootfilter="SA_OPOrg.sFName LIKE '%"+like+"%'";还是过滤不出来

jishuang

http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035
把具体的sql打出来看看执行的sql是什么

lwcompany

2016-12-15 12:37:57 加载模块：/SA/doc/logic ...
2016-12-15 12:37:57 加载模块：/SA/doc/logic/code ...
2016-12-15 12:37:57 [SQL Time]sql 执行时间：0ms, exec KSQL: select SA_DocLinkDefine,SA_DocLinkDefine.sDefineItems,SA_DocLinkDefine.sActivity,SA_DocLinkDefine.sPersonFID from SA_DocLinkDefine SA_DocLinkDefine where (SA_DocLinkDefine.sProcess='/guojinerp/tczjrbb/process/zjrbb/inputzjrbb/inputzjrbbProcess' and (SA_DocLinkDefine.sActivity='' or SA_DocLinkDefine.sActivity IS NULL)) or (SA_DocLinkDefine.sProcess='/guojinerp/tczjrbb/process/zjrbb/inputzjrbb/inputzjrbbProcess' and SA_DocLinkDefine.sActivity='mainActivity')  order by SA_DocLinkDefine.sActivity desc
  --> sql:SELECT  SA_DocLinkDefine.sID, SA_DocLinkDefine.SDEFINEITEMS AS sDefineItems, SA_DocLinkDefine.SACTIVITY AS sActivity, SA_DocLinkDefine.SPERSONFID AS sPersonFID FROM SA_DocLinkDefine SA_DocLinkDefine  WHERE  ( (SA_DocLinkDefine.SPROCESS = ?) AND ( (SA_DocLinkDefine.SACTIVITY = ?) OR (SA_DocLinkDefine.SACTIVITY IS NULL) ) ) OR ( (SA_DocLinkDefine.SPROCESS = ?) AND (SA_DocLinkDefine.SACTIVITY = ?) )   ORDER BY SA_DocLinkDefine.SACTIVITY DESC
--> binds:[/guojinerp/tczjrbb/process/zjrbb/inputzjrbb/inputzjrbbProcess, , /guojinerp/tczjrbb/process/zjrbb/inputzjrbb/inputzjrbbProcess, mainActivity]
2016-12-15 12:37:57 [SQL Time]sql 执行时间：0ms, 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, 20
  --> 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]
2016-12-15 12:37:57 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) )
--> binds:[0, 1]
2016-12-15 12:37:58 [SQL Time]sql 执行时间：0ms, 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, 20
  --> 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]
2016-12-15 12:37:58 [SQL Time]sql 执行时间：15ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) )
--> binds:[0, 1]
2016-12-15 12:38:01 [SQL Time]sql 执行时间：0ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg.sParent='ORG01')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20
  --> 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 = ?) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1, ORG01]
2016-12-15 12:38:01 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent = ?) )
--> binds:[0, 1, ORG01]
2016-12-15 12:38:03 [SQL Time]sql 执行时间：0ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg.sParent='VZ7VScuQds3ihWL12CN')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20
  --> 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 = ?) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1, VZ7VScuQds3ihWL12CN]
2016-12-15 12:38:03 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent = ?) )
--> binds:[0, 1, VZ7VScuQds3ihWL12CN]

jishuang

看orgSelectPC在点下拉的时候控制台输出的sql啊

lwcompany

2016-12-15 16:16:14 [SQL Time]sql 执行时间：0ms, 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, 20
  --> 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]
2016-12-15 16:16:14 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) )
--> binds:[0, 1]
2016-12-15 16:16:15 [SQL Time]sql 执行时间：0ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg.sParent='ORG01')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20
  --> 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 = ?) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1, ORG01]
2016-12-15 16:16:15 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent = ?) )
--> binds:[0, 1, ORG01]
2016-12-15 16:16:17 [SQL Time]sql 执行时间：0ms, exec KSQL: SELECT SA_OPOrg.*  FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState = 1) AND (SA_OPOrg.sParent='VZ7VScuQds3ihWL12CN')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20
  --> 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 = ?) )   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0, 1, VZ7VScuQds3ihWL12CN]
2016-12-15 16:16:17 [SQL Time]sql 执行时间：0ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg  WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent = ?) )
--> binds:[0, 1, VZ7VScuQds3ihWL12CN]

jishuang

很明显sql中没有你的条件啊

具体代码发一下看看