|
版本: |
X5.2.6 |
小版本号: |
|
|
|
数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
本帖最后由 liangfuting 于 2013-11-11 12:38 编辑
我自定义一个KSQL查询语句源代码如下:
select X5_FYSQ,X5_FYSQ.version as version,X5_FYSQ.fSQBM as fSQBM,X5_FYSQ.fSQR as fSQR,X5_FYSQ.fJE as fJE,X5_FYSQ.fSQSJ as fSQSJ,X5_FYSQ.fYT as fYT,X5_FYSQ.fSFXYSJPZ as fSFXYSJPZ
from X5_FYSQ X5_FYSQ
where X5_FYSQ.fSQSJ >= :firstDateOfMonth( :toDate( :p)) AND X5_FYSQ.fSQSJ <= :lastDateOfMonth( :toDate( :p))
变量P是从前面页面传入的字符串,前面JS内容如下:
var ksqlReport = {};
ksqlReport.refresh = function(event){
var pName = document.getElementById('pName').value;
justep.xbl('ds1').setStringVar('p', pName);
justep.xbl('gridReport').refresh();
};
需要完成的功能是输入一个日期,查询当月的费用申请数据
前台页面调用截图:
前台
可每次执行时,都会报firstDateOfMonth 和toDate函数出错,请大神解决。
出错信息如下:Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select X5_FYSQ,X5_FYSQ.version as version,X5_FYSQ.fSQBM as fSQBM,X5_FYSQ.fSQR as fSQR,X5_FYSQ.fJE as fJE,X5_FYSQ.fSQSJ as fSQSJ,X5_FYSQ.fYT as fYT,X5_FYSQ.fSFXYSJPZ as fSFXYSJPZ from X5_FYSQ X5_FYSQ where X5_FYSQ.fSQSJ >= :firstDateOfMonth( :toDate( :p)) AND X5_FYSQ.fSQSJ <= :lastDateOfMonth( :toDate( :p)) 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.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 25 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数firstDateOfMonth出错
at com.justep.model.exception.ModelException.create(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parameterNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.constExpression(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)
... 30 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数toDate出错
at com.justep.model.exception.ModelException.create(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
... 46 more
Caused by: java.lang.NullPointerException
at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
... 55 more
|
|