|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
RT 在主从表的流程查询中,我想根据从表中人员的ID来过滤数据 代码如下- queryActivity1.model1Load = function(event){
- var data = justep.xbl('dataMain');
- var detail = justep.xbl('dataDetail');
- // var dt = detail.getJson().fSHRFID;
- alert("dt======>"+detail.getValue("fSHR"));
- var fID = justep.Context.getCurrentPersonMemberFID();
- var name = justep.Context.getCurrentPersonName();
- var filter = "Reimburse.fReimburseApplyID ='" + justep.Context.getCurrentPersonMemberFID() + "' ";
- filter += " or (Reimburse = 'ReimburseDetail.fQKSQID' and ReimburseDetail.fSHRFID = '"+fID+"')";
- filter += "or Reimburse.fCWR = '"+name+"' or Reimburse.fJHR = '"+name+"' or Reimburse.fZJL = '"+name+"' or Reimburse.fCEO = '"+name+"'";
- data.filters.setFilter("RMFilter", filter);
- alert(data.getFilter("RMFilter"));
- data.refreshData();
- };
复制代码 控制台报错如下- 2014-02-07 18:10:43 invokeActions error!
- com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
- at com.justep.system.action.Engine.invokeActions(Unknown Source)
- at com.justep.business.server.BusinessServer.doAction(Unknown Source)
- at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
- at com.justep.business.server.BusinessServer.excute(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
- at java.lang.Thread.run(Thread.java:595)
- Caused by: java.lang.reflect.InvocationTargetException
- at sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:592)
- at com.justep.system.action.Engine.invokeActions(Native Method)
- ... 21 more
- Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT Reimburse.* FROM Reimburse Reimburse WHERE ((Reimburse.fReimburseApplyID ='/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' or (Reimburse = 'ReimburseDetail.fQKSQID' and '/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' = ReimburseDetail.fSHRFID)or Reimburse.fCWR = 'admin' or Reimburse.fJHR = 'admin' or Reimburse.fZJL = 'admin' or Reimburse.fCEO = 'admin')) ORDER BY fReimburseTime DESC LIMIT 0, 15时出错!
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.BizData.query(Unknown Source)
- at BizProcedure.query(BizProcedure.java:12)
- ... 25 more
- Caused by: com.justep.model.exception.ModelException: 未申明的符号:ReimburseDetail.fSHRFID
- at com.justep.util.Utils.check(Unknown Source)
- at com.justep.system.ksql.parser.AbstractParser.checkSymTable(Unknown Source)
- at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
- ... 30 more
- 2014-02-07 18:10:43 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
- <action direct-execute="true" process="/SA/zhigao/process/ReimburseApply/reimburseApplyProcess" activity="queryActivity1" action-flag="__action_0__" executor="" execute-context="" name="queryReimburseAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(Reimburse.fReimburseApplyID ='/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' or (Reimburse = 'ReimburseDetail.fQKSQID' and '/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' = ReimburseDetail.fSHRFID)or Reimburse.fCWR = 'admin' or Reimburse.fJHR = 'admin' or Reimburse.fZJL = 'admin' or Reimburse.fCEO = 'admin')]]></xbiz:simple></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">15</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fReimburseContent,fReimburseApplyID,fReimburseApply,fReimburseID,fReimburseBalance,fReimburseChineseBalance,fReimburseTime,fIsOverBalance,fReasonForOverBalance,fReimburseAttachment,fReimburseFinancialAdvise,fReimbursePlanAdvise,fCWR,fJHR,fQKRName,fQKRID,fIsCEOS,fCEOAdvice,fZJL,fZJLAdvice,fCWTime,fZJLTime,fCEOTime,fPlanTime,fCEO,Reimburse]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fReimburseTime DESC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="Reimburse" sequence="fReimburseID,fQKRName,fReimburseContent,fReimburseBalance,fReimburseChineseBalance,fReimburseTime,space-column,version,fReimburseApplyID,fReimburseApply,fIsOverBalance,fReasonForOverBalance,fReimburseAttachment,fReimburseFinancialAdvise,fReimbursePlanAdvise,fCWR,fJHR,fQKRID,fIsCEOS,fCEOAdvice,fZJL,fZJLAdvice,fCWTime,fZJLTime,fCEOTime,fPlanTime,fCEO,recNO"/></translate-parameter></action>
- com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
- at com.justep.system.action.Engine.invokeActions(Unknown Source)
- at com.justep.business.server.BusinessServer.doAction(Unknown Source)
- at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
- at com.justep.business.server.BusinessServer.excute(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
- at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
- at java.lang.Thread.run(Thread.java:595)
- Caused by: java.lang.reflect.InvocationTargetException
- at sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:592)
- at com.justep.system.action.Engine.invokeActions(Native Method)
- ... 21 more
- Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT Reimburse.* FROM Reimburse Reimburse WHERE ((Reimburse.fReimburseApplyID ='/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' or (Reimburse = 'ReimburseDetail.fQKSQID' and '/F5E46823A9E3427B86073E4EC33C02D1.ogn/24926D36DE42407787B1E96B756019F5.dpt/DC0500662A5847E18DD5212E5BF24935.pos/51B66B9E03E74177A354624F6ABD2365@DC0500662A5847E18DD5212E5BF24935.psm' = ReimburseDetail.fSHRFID)or Reimburse.fCWR = 'admin' or Reimburse.fJHR = 'admin' or Reimburse.fZJL = 'admin' or Reimburse.fCEO = 'admin')) ORDER BY fReimburseTime DESC LIMIT 0, 15时出错!
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
- at com.justep.system.data.BizData.query(Unknown Source)
- at BizProcedure.query(BizProcedure.java:12)
- ... 25 more
- Caused by: com.justep.model.exception.ModelException: 未申明的符号:ReimburseDetail.fSHRFID
- at com.justep.util.Utils.check(Unknown Source)
- at com.justep.system.ksql.parser.AbstractParser.checkSymTable(Unknown Source)
- at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
- ... 30 more
复制代码 |
|