grid 放了一个gridSelect1 级联下拉报错

谁用谁知道

1. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
   
2. at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
3. at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
4. at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
5. at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
6. at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
   
7. at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
   
8. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   
9. at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
   
10. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
11. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
12. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
13. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
14. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
15. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
16. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
17. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
18. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
19. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
20. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
21. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
22. at java.lang.Thread.run(Thread.java:595)
    
23. Caused by: java.lang.reflect.InvocationTargetException
    
24. at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
    
25. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
26. at java.lang.reflect.Method.invoke(Method.java:592)
    
27. at com.justep.system.action.Engine.invokeActions(Native Method)
    
28. ... 21 more
    
29. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT DISTINCT CR_TJXXSBMC.fXH as fXH FROM CR_TJXXSBMC CR_TJXXSBMC WHERE ((fMC='碳粉')) LIMIT 0, -1时出错！
    
30. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
31. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
32. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
33. at com.justep.system.data.BizData.query(Unknown Source)
    
34. at BizProcedure.query(BizProcedure.java:12)
    
35. ... 25 more
    
36. Caused by: com.justep.model.exception.ModelException: 找不到fMC对应的符号！
    
37. at com.justep.util.Utils.check(Unknown Source)
    
38. at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
39. at com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)
    
40. at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
41. at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
42. at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
    
43. at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
44. at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
45. at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
    
46. at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
47. at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
48. at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
    
49. at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
50. at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
    
51. at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
    
52. ... 30 more
    
53. 
    
54. url:/UI/system/service/common/bizAction.j
    
55. param:{"process":"/CRKGL/CRKGL/process/RKGL/rKGLProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryCR_TJXXSBMC12Action","parameters":{"variables":{},"offset":0,"limit":-1,"columns":"fXH","filter":"(fMC='\u78b3\u7c89')"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"CR_TJXXSBMC","sequence":"fXH,__c_"}}}
    
56. at (http://10.164.100.114:8008/x5/$vded211048da64b25a617ee51211da3a9/component/data/data.js?language=zh_CN:1)
    

复制代码

mainActivity.gridSelect1Dropdown = function(event){
var data = justep.xbl("bizData2");
var fMC = justep.xbl("dataDetail").getValue("fMC");
data.setFilter("fMC", "fMC='" + fMC + "'");
data.refreshData();
};


报错提示刷新数据失败！ 执行ksql:SELECT DISTINCT CR_TJXXSBMC.fXH as fXH FROM CR_TJXXSBMC CR_TJXXSBMC WHERE ((fMC='碳粉')) LIMIT 0, -1时出错！

fpj

你这样写，

SELECT DISTINCT CR_TJXXSBMC.fXH as fXH FROM CR_TJXXSBMC CR_TJXXSBMC WHERE ((CR_TJXXSBMC.fMC='碳粉'))

梦毁夕颜

重新生成数据库 吧action删了 重新添加

谁用谁知道

按照fpj 说的，问题解决，可以结贴了。

fpj

谁用谁知道 发表于 2013-12-31 10:30
按照fpj 说的，问题解决，可以结贴了。

具体解决如下
将
data.setFilter("fMC", "fMC='" + fMC + "'");
改为
data.setFilter("fMC", "CR_TJXXSBMC.fMC='" + fMC + "'");

谁用谁知道

happytsgf 发表于 2013-12-31 13:25
KSQL不同于SQL，KSQL 把每个表都当成个对象(A)了，查某个对象的字段要  A.字段，如果是找fID，就直接 A 自 ...

谢谢