如何在hql中使用中间子句
如何在hql中使用中间子句
提问于 2016-11-02 16:21:48
有人能说出请求中有什么问题吗？
@Query( "SELECT new com.app.gsc.entities.ListeBI(lm.listeDeCriteres.designation,count(*) as totalNumber,lm.ficheDeMission.dateEtHeurDeDepart) from ListeDeControleDetailsMission lm where lm.boolDepart=false AND Year(lm.ficheDeMission.dateEtHeurDeDepart)=:year AND Month(lm.ficheDeMission.dateEtHeurDeDepart) >= Month(lm.ficheDeMission.dateEtHeurDeDepart)=:FromMonth AND Month(lm.ficheDeMission.dateEtHeurDeDepart) <= Month(lm.ficheDeMission.dateEtHeurDeDepart)=:ToMonth GROUP BY lm.listeDeCriteres.designation" )
List<ListeBI> getIncidentDepartByFromToMonth( @Param( "FromMonth" ) int FromMonth, @Param( "ToMonth" ) int ToMonth,
@Param( "year" ) int year );错误信息：
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: >= near line 1, column 322 [SELECT new com.app.gsc.entities.ListeBI(lm.listeDeCriteres.designation,count(*) as totalNumber,lm.ficheDeMission.dateEtHeurDeDepart) from com.app.gsc.entities.ListeDeControleDetailsMission lm where lm.boolDepart=false AND Year(lm.ficheDeMission.dateEtHeurDeDepart)=:year AND Month(lm.ficheDeMission.dateEtHeurDeDepart) >= Month(lm.ficheDeMission.dateEtHeurDeDepart)=:FromMonth AND Month(lm.ficheDeMission.dateEtHeurDeDepart) <= Month(lm.ficheDeMission.dateEtHeurDeDepart)=:ToMonth GROUP BY lm.listeDeCriteres.designation]回答 1
Stack Overflow用户
回答已采纳
发布于 2016-11-02 17:46:52
它必须是这一部分：Month(lm.ficheDeMission.dateEtHeurDeDepart) >= Month(lm.ficheDeMission.dateEtHeurDeDepart)=:FromMonth。我想说的是，你的三个比较有问题。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/40384867
复制相关文章
相似问题
腾讯云开发者
