怎样通过label、input和查询按钮控件，然后输入的查询条件....

justep_hzj

Grid绑定了bizdata。不想用系统封装好的bizfilter组件；想在前台自己放几个label、input和查询按钮控件，然后输入的查询条件，通过单击查询按钮，
能过滤出来查询的记录。怎样实现？

jishuang

那就自己获取input中输入的值，通过data的setFilter方法设置过滤调用并过滤数据
setFilter方法在API中有说明

justep_hzj

这段代码红色部分，报错！

Model.prototype.button1Click = function(event){
                var curData = this.comp('mainData');
                var input3 = this.comp('input3').val();
                curData.setFilter('filter1', 'CA_BYJSC.fSBBH = :input3');
                curData.refreshData();
                curData.filters.clear();
        };

怎样把input输入控件的值，传入setFilter的第二个参数。

jishuang

curData.setFilter('filter1', 'CA_BYJSC.fSBBH ='"+input3+"'');

justep_hzj

前台js代码不报错，点击查询按钮报错，
刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT CA_BYJSC.* FROM CA_BYJSC CA_BYJSC WHERE ((CA_BYJSC.fRQSJ >=justep.Date.fromString("2017-05-22T09:47:04.331Z","yyyy-MM-dd hh:mm")) AND (CA_BYJSC.fRQSJ <=justep.Date.fromString("2018-05-22T09:47:07.882Z","yyyy-MM-dd hh:mm")) AND (CA_BYJSC.fSBBH ="byj001") AND (CA_BYJSC.fSBMC ="包衣机001")) LIMIT 0, 20
--> sql:
--> binds: []
编码：JUSTEP150210
[url=]显示详细[/url]


[url=]前台js代码：[/url]
[url=]        Model.prototype.button1Click = function(event){
                var curData = this.comp('mainData');
                var input6 = this.comp('input6').val();
                var input2 = this.comp('input2').val();
                var input3 = this.comp('input3').val();
                var input5 = this.comp('input5').val();
               
                curData.setFilter('filter1', "CA_BYJSC.fRQSJ >=" + "justep.Date.fromString(" + '"' + input6 + '"' + ',' + '"' + 'yyyy-MM-dd hh:mm' + '"' + ")" );//input6 是datatime类型
                curData.setFilter('filter2', "CA_BYJSC.fRQSJ <=" + "justep.Date.fromString(" + '"' + input2 + '"' + ',' + '"' + 'yyyy-MM-dd hh:mm' + '"' + ")" );//input2 是datatime类型
                curData.setFilter('filter3', 'CA_BYJSC.fSBBH =' + '"'+ input3 + '"');
                curData.setFilter('filter4', 'CA_BYJSC.fSBMC =' + '"'+ input5 + '"');
                curData.refreshData();
                curData.filters.clear();
        };

是前台js代码的问题，还是其他原因？
[/url]

justep_hzj

详细信息

隐藏详细
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 CA_BYJSC.* FROM CA_BYJSC CA_BYJSC WHERE ((CA_BYJSC.fRQSJ >=justep.Date.fromString("2017-05-22T09:47:04.331Z","yyyy-MM-dd hh:mm")) AND (CA_BYJSC.fRQSJ <=justep.Date.fromString("2018-05-22T09:47:07.882Z","yyyy-MM-dd hh:mm")) AND (CA_BYJSC.fSBBH ="byj001") AND (CA_BYJSC.fSBMC ="包衣机001")) LIMIT 0, 20
--> 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 BizProcedure.query(BizProcedure.java:12)
... 27 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, J >=justep.Date^^.fromString("20中未找到需要的元素, 位置78期望是)
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.conditionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.whereExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 32 more

jishuang

justep.Date.fromString是js函数不能在ksql中用

可以在js中通过js转换用变量的方式在ksql中用，或者用ksql提供的函数

justep_hzj

找到一个简单的方法：

Model.prototype.button1Click = function(event){
                var xh = this.comp('input1').val();
                var xm = this.comp('input2').val();
                var curData = this.comp('mainData');
                curData.setFilter('filter2', "CA_XSXXB.fXH = :xuehao and CA_XSXXB.fXM = :xingming");
                curData.filters.setStringVar('xuehao',xh);
                curData.filters.setStringVar('xingming',xm);
                curData.refreshData();
                curData.filters.clear();
        };