数据集过滤设置

qweasdzxc

我的这个bizData设了filter过滤后打印出来的SQL条件后面为什么多了and 1=0，检查就只有这个filter.

1. Model.prototype.modelParamsReceive = function(event){
   
2.         debugger
   
3.             var rowID=this.getContext().getRequestParameter('rowID');
   
4.             var title=this.getContext().getRequestParameter('title');
   
5.             var mainData=this.comp("MData");
   
6.             mainData.setFilter("filter1", "HR_emp_TransferApplyM = '"+rowID+"'");
   
7.             alert(mainData.filters);
   
8.             mainData.refreshData();
   
9.         };

复制代码

打印的sql如下：

1. 2018-03-01 16:39:36 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT HR_emp_TransferApplyM.*  FROM HR_emp_TransferApplyM HR_emp_TransferApplyM WHERE ((HR_emp_TransferApplyM = 'FBB97D25BE4E4FE69A07A41B529B539A') AND (1=0)) LIMIT 0, 1
   
2.   --> sql:SELECT  HR_emp_TransferApplyM.fID AS HR_emp_TransferApplyM, HR_emp_TransferApplyM.FBIZSTATE AS fBizState, HR_emp_TransferApplyM.FBIZSTATENAME AS fBizStateName, HR_emp_TransferApplyM.FCREATEDEPTID AS fCreateDeptID, HR_emp_TransferApplyM.FCREATEDEPTNAME AS fCreateDeptName, HR_emp_TransferApplyM.FCREATEOGNID AS fCreateOgnID, HR_emp_TransferApplyM.FCREATEOGNNAME AS fCreateOgnName, HR_emp_TransferApplyM.FCREATEPOSID AS fCreatePosID, HR_emp_TransferApplyM.FCREATEPOSNAME AS fCreatePosName, HR_emp_TransferApplyM.FCREATEPSNFID AS fCreatePsnFID, HR_emp_TransferApplyM.FCREATEPSNFNAME AS fCreatePsnFName, HR_emp_TransferApplyM.FCREATEPSNID AS fCreatePsnID, HR_emp_TransferApplyM.FCREATEPSNNAME AS fCreatePsnName, HR_emp_TransferApplyM.FCREATETIME AS fCreateTime, HR_emp_TransferApplyM.FCURRENTACTIVITIES AS fCurrentActivities, HR_emp_TransferApplyM.FCURRENTEXECUTORS AS fCurrentExecutors, HR_emp_TransferApplyM.FISWHEMOVE AS fIswheMove, HR_emp_TransferApplyM.FREMARK AS fRemark, HR_emp_TransferApplyM.FTITLE AS fTitle, HR_emp_TransferApplyM.VERSION AS version FROM HR_EMP_TRANSFERAPPLYM HR_emp_TransferApplyM  WHERE  (HR_emp_TransferApplyM.fID = ?) AND (? = ?)
   
3. --> binds:[FBB97D25BE4E4FE69A07A41B529B539A, 1, 0]

复制代码

jishuang

process组件上的autoFilter设置为false

qweasdzxc

jishuang 发表于 2018-3-1 17:00
process组件上的autoFilter设置为false

结贴