在case when then的情况下如何编写hql子查询？

Question

SELECT rd.rdKey AS rdKey,
(
    CASE
      WHEN 
          replace (translate(rd.rdOpr1Value,'0123456789','0000000000'),'0','') is null
      THEN  
          COALESCE
          (
             SELECT c.isForeighn FROM ColumnMap c WHERE                              c.columnmapkey=rd.rdOpr1Value,'N'
          )
      ELSE 'N'
   END
) AS foreignYN,
rd.rdSetNO AS rdSetNO,
rd.createdUser AS createdUser,
rd.createdDateTime AS createdDateTime,
rd.updatedUser AS updatedUser,
rd.updatedDateTime AS updatedDateTime
FROM RuleDetail rd 
where rd.rdKey = 1;

对于上面的查询，我得到了错误

Answer 1

Hibernate中不支持此功能。但确实存在一种变通方法。在数据库中创建一个视图，然后使用HQL通过Java获取结果。

创建或替换force view VW_ENTITY_VALUE(entityValue)作为select大小写（当.EntityId为null时，然后使用'invalid'else（从tblName b中选择b.entityName，其中b.entityId=A.entityId）从tblEntity A中结束；

摘自HQL文档:http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html#queryhql-subqueries

14.13.子查询

对于支持子选择的数据库，Hibernate支持查询中的子查询。子查询必须用括号包围（通常用SQL聚合函数调用包围）。甚至允许关联子查询（在外部查询中引用别名的子查询）。

from Cat as fatcat where fatcat.weight>（从DomesticCat Cat中选择avg（Cat.weight））from DomesticCat as Cat where Cat.Name=some（从Name as Name中选择Name.nickname）from DomesticCat as Cat where not exists（从Cat as mate where mate.mate=Cat）from DomesticCat as Cat where Cat.Name not in（从Name as Name中选择Name.nickname）select Cat.id,（从Cat.kiten kit中选择max（