关于按组织机构名称过滤人员报错的问题

hailong

想要实现：界面上，在保管单位列，点击按钮弹出orgDialogPC1的组织机构窗口，选择部门名称，然后保管员列点击按钮弹出orgDialogPC2的窗口，orgDialogPC2的窗口要根据部门名称过滤，只显示本部门的人员，orgDialogPC2的selectfilter属性设置：$row.val('sOrgKindID') === 'psm'

        Model.prototype.button2Click = function(event){  //选择保管员button2
          var detailData = this.comp("detailData");//从表：出门证明细
          var scode=detailData.getValue("fBGDWID");//保管单位SCODE
          var sfcode="/0010000000/"+scode+"%";
          this.comp("orgDialogPC2").open({"rootFilter":"SFCODE LIKE '"+sfcode+"'","limit":-1});
        };
报错：
刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1) AND (SA_OPOrg.sValidState=1) AND (SFCODE LIKE '/0010000000/0010010000%')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
--> sql:
--> binds: []
编码：JUSTEP150210
隐藏详细
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.system.action.Engine.invokeActions(Native Method)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1) AND (SA_OPOrg.sValidState=1) AND (SFCODE LIKE '/0010000000/0010010000%')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(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.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at com.justep.system.opm.OrgQuery.query(Unknown Source)
at OPMProcedure.query(OPMProcedure.java:117)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154054; 提示: KSQL语法错误, SFCODE找不到对应的符号描述
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
... 33 more

liangyongfei

sql语句自己在数据库管理工具中执行一下吧！

我试了一下
把
LIMIT 0, -1 去掉就可以正常执行了！

hailong

sql语句执行是没问题的，但是这里是ksql啊，去掉limit还是一样的错误

liangyongfei

hailong 发表于 2017-5-3 12:14
sql语句执行是没问题的，但是这里是ksql啊，去掉limit还是一样的错误

去掉limit报什么错？？
打印一下sql日志！ 完整 执行 的ksql是什么？？

hailong

去掉limit报的错貌似和去掉前的错误一样。
改成以下这样好使了，达到预期的效果，参考同事的例子改的，但是不太明白为什么是SA_OPOrg
          var detailData = this.comp("detailData");//从表：出门证明细
           var scode=detailData.getValue("fBGDWID");//保管单位                  var fBGDWID= event.data[0].row.SA_OPOrg.value.latestValue;              
                 //   而不是 event.data[0].row.sCode.value.latestValue;
          orgSql = "SA_OPOrg = \'"+scode+"\'";
          this.comp("orgDialogPC2").open({"rootFilter": orgSql});

hailong

还有个问题，input控件鼠标点中它会显示数据内容，不点击显示不出来数据，什么原因

liangyongfei

hailong 发表于 2017-5-3 16:15
还有个问题，input控件鼠标点中它会显示数据内容，不点击显示不出来数据，什么原因 ...

是grid组件吗？？
调用grid.refresh()  刷新下试试！

hailong

解决了，grid#column的ref和input的ref不一致，之前改过input的引用字段，忘记改grid#column的ref了
谢谢回复，结贴