jpa HQL意外AST节点

jgwigjjp  于 2022-11-14  发布在  其他
关注(0)|答案(1)|浏览(124)

在HQL中查询时出现以下错误
异常原因:意外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) " )

任何提示都将不胜感激。

cngwdvgl

cngwdvgl1#

既然“拥有”应该是一个条件,我认为它必须是

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

相关问题