HQL意外的AST节点

Question

我在HQL 中的查询出现以下错误

由：org.hibernate.hql.internal.ast.QuerySyntaxException引起：意外的ast节点：第1行附近的COUNT

我的查询在之后

@Query("SELECT new com.model.CompanyInfoMapping(c.company_id, c.company_name)"
+ "FROM Company c Inner JOIN c.companyInfo ci INNER JOIN c.portfolioPrivate ppc               "
+ " WHERE (ppc.beschreibung_id ='1'  AND ppc.value = 'Yes') "
+ " OR (ppc.beschreibung_id ='2'  AND ppc.value = 'Yes')" 
+ " GROUP BY c.company_id "
+ " HAVING COUNT(CASE WHEN ppc.value ='Yes' THEN 1  ELSE 0 END) " )

任何提示都将不胜感激。

Answer 1

由于HAVING应该是一个条件，我认为它需要是

+ " HAVING COUNT(CASE WHEN ppc.value ='Yes' THEN 1  ELSE 0 END) > 0 " )