filter过滤条件总是报错

usb0.o

1. selectActivity2.windowReceiverReceive = function(event){
   
2.                 var data = justep.xbl('main');
   
3.                 var date = new Date;
   
4.                 var year = date.getFullYear();
   
5.                 var filterStr = "GZ_BudgetMain.fYear = '"  +  year + "'";        //只能选本年的
   
6.                 filterStr = filterStr + " and GZ_Budgetfrozen.fFrozenAmount > 0";        //只能选冻结金额不为0的
   
7.                 if(event.data && event.data.bm){        //只能选本部门的
   
8.                         filterStr = filterStr + " and GZ_Budgetfrozen.fDepartment = '"  +  event.data.bm + "'";
   
9.                 }
   
10.                 if(event.data && event.data.r){                //只能选本人的
    
11.                         filterStr = filterStr + " and GZ_BudgetFrozen.fCreateUser = '"  +  event.data.r + "'";
    
12.                 }
    
13.                 data.filters.setFilter('filter1',filterStr);
    
14.                 data.setOrderBy("fCreateDtim", 0);        //按创建时间逆序排
    
15.                 data.refreshData();
    
16. };
    

复制代码

提示如下错误，可是我在HeidiSQL Portable里执行以下语句正常，也就是说 GZ_Budgetfrozen.fFrozenAmount这个字段是存在的，数据类型是Decimal
select * from GZ_Budgetfrozen GZ_Budgetfrozen where GZ_Budgetfrozen.fFrozenAmount > 0

请帮忙看看是什么问题？谢谢！

1. 
   
2. 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT GZ_BudgetFrozen.*,GZ_BudgetMain.fYear as fYear,GZ_BudgetMain.fParentColumn as fParentColumn,GZ_BudgetMain.fSonColumn as fSonColumn,GZ_BudgetMain.fDepartment as fDepartment FROM GZ_BudgetFrozen GZ_BudgetFrozen optional join GZ_BudgetMain GZ_BudgetMain on GZ_BudgetFrozen.fMasterID = GZ_BudgetMain WHERE ((GZ_BudgetMain.fYear = '2016' and GZ_Budgetfrozen.fFrozenAmount > 0 and GZ_Budgetfrozen.fDepartment = '测试部' and GZ_BudgetFrozen.fCreateUser = '测试')) ORDER BY fCreateDtim DESC LIMIT 0, 10
   
3. --> sql:
   
4. --> binds: []
   
5. 编码: JUSTEP154041; 提示: KSQL语法错误, 未声明的符号GZ_Budgetfrozen.fFrozenAmount
   
6. 
   
7. java.lang.reflect.InvocationTargetException
   
8. at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source)
   
9. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
10. at java.lang.reflect.Method.invoke(Method.java:606)
    
11. at com.justep.system.action.Engine.invokeActions(Native Method)
    
12. at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
13. at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
14. at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
15. at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
16. at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
17. at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
18. at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
19. at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
20. at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
21. at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
22. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
23. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
24. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
25. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
26. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
27. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
28. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
29. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
30. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
31. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
32. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
33. at java.lang.Thread.run(Thread.java:745)
    
34. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT GZ_BudgetFrozen.*,GZ_BudgetMain.fYear as fYear,GZ_BudgetMain.fParentColumn as fParentColumn,GZ_BudgetMain.fSonColumn as fSonColumn,GZ_BudgetMain.fDepartment as fDepartment FROM GZ_BudgetFrozen GZ_BudgetFrozen optional join GZ_BudgetMain GZ_BudgetMain on GZ_BudgetFrozen.fMasterID = GZ_BudgetMain WHERE ((GZ_BudgetMain.fYear = '2016' and GZ_Budgetfrozen.fFrozenAmount > 0 and GZ_Budgetfrozen.fDepartment = '测试部' and GZ_BudgetFrozen.fCreateUser = '测试')) ORDER BY fCreateDtim DESC LIMIT 0, 10
    
35. --> sql:
    
36. --> binds: []
    
37. at com.justep.exception.BusinessException.create(Unknown Source)
    
38. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
39. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
40. at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
41. at com.justep.system.data.BizData.query(Unknown Source)
    
42. at BizProcedure.query(BizProcedure.java:137)
    
43. ... 26 more
    
44. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154041; 提示: KSQL语法错误, 未声明的符号GZ_Budgetfrozen.fFrozenAmount
    
45. at com.justep.exception.BusinessException.create(Unknown Source)
    
46. at com.justep.util.Utils.check(Unknown Source)
    
47. at com.justep.system.ksql.parser.AbstractParser.checkSymTable(Unknown Source)
    
48. at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
    
49. ... 31 more
    
50. 
    
51. url:/UI/system/service/common/bizAction.j
    
52. param: 0 and GZ_Budgetfrozen.fDepartment = '测试部' and GZ_BudgetFrozen.fCreateUser = '测试')]]>010
    
53. at (http://oa.gzhjat.com:8088/x5/v_7e7fd9e4519641c8b3a18d180becee45l_s_d_/base/base.js?language=zh_CN:1)69

复制代码

jishuang

确认概念中有fFrozenAmount这个关系吗？确认大小写是否正确

如果概念中存在，在bizdata的relations中看看是否有这个关系

usb0.o

jishuang 发表于 2016-1-20 14:33
确认概念中有fFrozenAmount这个关系吗？确认大小写是否正确

如果概念中存在，在bizdata的relations中看看 ...

都有

jishuang

换其他的关系都没问题？

usb0.o

jishuang 发表于 2016-1-20 17:08
换其他的关系都没问题？

是的

jishuang

把ontology文件发一下看看

usb0.o

jishuang 发表于 2016-1-26 09:14
把ontology文件发一下看看

请查收附件

jishuang

在grid中添加这个关系看看是否可以过滤

usb0.o

jishuang 发表于 2016-1-26 15:09
在grid中添加这个关系看看是否可以过滤

解决了，发现一个貌似是平台BUG的东东，

Decimal类型即使在ontology里设置了精度2，生成数据库表后在MySQL里却仍是(10,0)精度为0，我也是流转了几张单子之后才发现小数点后的不见了，然后手工把它改成(10,2)就不报这个错了。

请帮忙确认一下是我的个例还是真有BUG？谢谢

jishuang

你好楼主，您反馈的这个现象通过验证是产品缺陷，我们已提交到产品组(内部编号：2016012600048)，感谢楼主的支持与配合。