设置gridfilter报错

fangyeer

设置如图1报错如下Unable to process binding "component: function (){return {name:'$model/UI2/system/components/justep/grid/grid'} }"
Message: Cannot read property 'defCols' of undefined
隐藏详细
TypeError: Unable to process binding "component: function (){return {name:'$model/UI2/system/components/justep/grid/grid'} }" Message: Cannot read property 'defCols' of undefined at n._processColCfg (eval at <anonymous> (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:1:1), <anonymous>:207:325204) at n._processCfg (eval at <anonymous> (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:1:1), <anonymous>:207:329948) at n.init (eval at <anonymous> (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:1:1), <anonymous>:207:323653) at Object.init (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:248593) at Object._init1 (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:160186) at init (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:160704) at http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:150148 at Object.ignore (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:121901) at http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:150124 at Object.arrayForEach (http://127.0.0.1:8080/x5/UI2/v_568d200cb0a240669ea8bdd78ecabfacl_zh_CNs_desktopd_pc/system/core.min.js:71:105040)

图1

jishuang

gridFilter中的gridSelect中的属性没有设置

fangyeer

现在好了，但是为了去重，我按贴子里设置如图1但是报错如图2

图一

图二

jishuang

F12打开浏览器的开发人员调试工具看看console中的完整错误信息

fangyeer

打不开当前页面了

fangyeer

Uncaught Error: __justepServerErrorStart__{"message":"刷新数据失败！ , \n执行KSQL出错, KSQL: SELECT DISTINCT DE_Weqeqwe.fDJZT as fDJZT  FROM DE_Weqeqwe DE_Weqeqwe ORDER BY fCLRQ ASC LIMIT 0, 20\r\n --> sql: \r\n --> binds: []","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT DISTINCT DE_Weqeqwe.fDJZT as fDJZT  FROM DE_Weqeqwe DE_Weqeqwe ORDER BY fCLRQ ASC LIMIT 0, 20\r\n --> sql: \r\n --> binds: []\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.BizData.query(Unknown Source)\r\n\tat BizProcedure.query(BizProcedure.java:12)\r\n\t... 27 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP154054; 提示: KSQL语法错误, fCLRQ找不到对应的符号描述\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.util.Utils.check(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)\r\n\tat com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)\r\n\tat com.justep.system.ksql.node.OrderNode.accept(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)\r\n\tat com.justep.system.ksql.node.OrderByNode.accept(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)\r\n\tat com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)\r\n\tat com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)\r\n\tat com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)\r\n\t... 32 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT DISTINCT DE_Weqeqwe.fDJZT as fDJZT  FROM DE_Weqeqwe DE_Weqeqwe ORDER BY fCLRQ ASC LIMIT 0, 20\r\n --> sql: \r\n --> binds: []","编码: JUSTEP154054; 提示: KSQL语法错误, fCLRQ找不到对应的符号描述"],"url":"http://127.0.0.1:8080/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/demo1/listProcess/process/listProcess/listProcessProcess","activity":"listActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryDE_WeqeqweAction","parameters":{"variables":{},"offset":0,"limit":20,"columns":"fDJZT","orderBy":"fCLRQ ASC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"fDJZT","sequence":"calcCheckBox,fDJZT"}}}}__justepServerErrorEnd__
    at Object.create (core.min.js:71)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.h (biz.common.min.js:12)
    at f (core.min.js:71)
    at Object.add (core.min.js:71)
    at _sendRequest (biz.common.min.js:12)
    at Object.Request.sendRequest (biz.common.min.js:12)
    at Object.$var._sendBizRequest (eval at __actionFinish (biz.common.min.js:12), <anonymous>:1:577)
    at Object.Request.sendBizRequest (biz.common.min.js:12)

fangyeer

我这是哪里没改对？

jishuang

action返回的只有fDJZT，那么就只能用fDJZT，不能用 fCLRQ

fangyeer

那我这里重复怎么去掉呀？如图

fangyeer

已解决，新建一个data,用于过滤