KSQL里调用通用函数出错~

X5_yxd

select qd.fLXID from OA_RYQD qd
where qd.fLXID = :qdlxID
and getYear(dateTimeToDate(qd.fQDSJ)) = :yearOf(:currentDateTime())
and getMonth(dateTimeToDate(qd.fQDSJ)) = :monthOf(:currentDateTime())
and getDay(dateTimeToDate(qd.fQDSJ)) = :dayOf(:currentDateTime())

系统报错如下：
Caused by: com.justep.model.exception.ModelException: 执行ksql:select qd.fLXID from OA_RYQD qd where qd.fLXID = :qdlxID and getYear(dateTimeToDate(qd.fQDSJ)) = :yearOf(:currentDateTime()) and getMonth(dateTimeToDate(qd.fQDSJ)) = :monthOf(:currentDateTime()) and getDay(dateTimeToDate(qd.fQDSJ)) = :dayOf(:currentDateTime())时出错！
        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 WorkTime.CurDaySignRecord_(WorkTime.java:23)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 执行函数是出错：yearOf
        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)
        ... 31 more

zhaixin

yearOf的参数类型是date，不是datetime

X5_yxd

zhaixin 发表于 2013-7-5 09:12
yearOf的参数类型是date，不是datetime

使用 currentDate()，结果也是一样。。。。。。
咋回事呢？

zhaixin

内存函数不支持嵌套，yaerof改为getyear吧

X5_yxd

zhaixin 发表于 2013-7-5 11:19
内存函数不支持嵌套，yaerof改为getyear吧

果然如上~
谢谢了~