想做一个时间过滤，请指点！！！！

fangyeer

用10楼的时间段来过滤我的送货时间fSHSJ，现在别的都解决了，就是你说的用setfilter后面的语句弄不懂，

fangyeer

我给maindata新建过滤filter0,然后我现在是这样做的如图
在查看的点击事件中我是这样写的：
Model.prototype.button2Click = function(event){
        var start=this.comp('start').val();
                var end=this.comp('end').val();
                if(start!==''&&end!==""){
                this.comp("mainData").setFilter("filter0","SO_KHZL.fSHSJ between :start and :end");

               
               
                }else{
                justep.Util.hint("时间不完整");
                }
        this.comp('mainData').refreshData();

        };
现在控制台报错如下：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量start对应的值
        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.VariableNode.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.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)
        ... 31 more
请问是什么原因？

fangyeer

2017-07-16 01:20:26 excute stream action, params:{"accept":"application/json","action":"querySO_KHZLAction","actionFlag":"__action_0__","activity":"listActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SO_KHZL,fDDJE,fDH,fDZ,fFWLX,fKDR,fLCZT,fSFKQ,fSFSW,fSFTH,fSHSJ,fTSSM,fXM,version","filter":"(SO_KHZL.fSHSJ between :start and :end)","limit":20,"offset":0,"orderBy":"fSHSJ DESC","variables":{}},"process":"/songhuorenwu/songhuo/process/songhuodan/songhuodanProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"SO_KHZL","sequence":"SO_KHZL,fDDJE,fDH,fDZ,fFWLX,fKDR,fLCZT,fSFKQ,fSFSW,fSFTH,fSHSJ,fTSSM,fXM,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
        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 SO_KHZL.*  FROM SO_KHZL SO_KHZL WHERE ((SO_KHZL.fSHSJ between :start and :end)) ORDER BY fSHSJ DESC 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)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量start对应的值
        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.VariableNode.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.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)
        ... 31 more

jishuang

this.comp("mainData").setFilter("filter0","SO_KHZL.fSHSJ between :start and :end");
改为

this.comp("mainData").setFilter("filter0","SO_KHZL.fSHSJ between '"+start+"' and '"+end+"'");

fangyeer

你好！大神我现在做好了，但是，我忽略了一个问题，就是按照上面的做出来，需要去点击按钮才能实现过滤，请问一下，怎么才能让他自动过滤，（就是打开页面时，就自动按照我的两个input,过滤，不用点击按钮）

fangyeer

大神，自动过滤maindata是不是直接把条件写到datafilter中去呀？我看data上建过滤filter0上双击会出现个条件框，

fangyeer

也可以通过在w页面中通过右键单击这个数据源：增加过滤条件，来进行过滤,请问这个过滤条件和js的写的是一样的吗？

jishuang

把data的autoLoad设置 为false
在model的onload中自己获取值，然后setFilter设置filter，调用data的refreshData()

fangyeer

我把autoload设成false,把autonew也设成false,打开页面时，不会有数据，点击查询可以查出时间段的数据，效果达到了，请问这样设置没问题吧？

jishuang

如果打开页面就要显示数据在model的onload中自己获取值，然后setFilter设置filter，调用data的refreshData()啊