在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) " )
任何提示都将不胜感激。
1条答案
按热度按时间cngwdvgl1#
既然“拥有”应该是一个条件,我认为它必须是