子选择中带有and子句的Hibernate DetachedCriteria查询
子选择中带有and子句的Hibernate DetachedCriteria查询
提问于 2014-11-21 03:49:59
我如何用Hibernate的分离标准来解决这个查询？对我来说，最困难的部分是将and u1.abrechnungsDatum is null放入子选择中。我想要一个这样的查询：
select *
from
patient as p
where
p.krankenstand = ?
and
? < ( select count(*) from ueberweisung u1 where p.id = u1.patient_id
and u1.abrechnungsDatum is null)我用这个试过了
DetachedCriteria dc = DetachedCriteria.forClass(Patient.class, "patient");
dc.add(Restrictions.eq("krankenstand", true));
DetachedCriteria nab = dc.createCriteria("ueberweisungs", "nab");
nab.add(Restrictions.isNull("nab.abrechnungsDatum"));
dc.add(Restrictions.sizeGt("ueberweisungs", 0));它给出了下面的SQL语句
select
*
from
patient this_
inner join
ueberweisung nab1_
on this_.id=nab1_.patient_id
where
this_.krankenstand=?
and nab1_.abrechnungsDatum is null
and ? < (
select
count(*)
from
ueberweisung
where
this_.id=patient_id
)如您所见，字段abrechnungsDatum的and-子句不在subselect内。我怎样才能把这个放进去呢？
Stack Overflow用户
发布于 2014-11-21 06:17:36
试着这样做：
DetachedCriteria dc = DetachedCriteria.forClass(Patient.class, "patient");
dc.add(Restrictions.eq("krankenstand", true));
DetachedCriteria subquery = DetachedCriteria.forClass(Ueberweisung.class);
subquery.add(Restrictions.isNull("abrechnungsDatum"));
dc.add(Subqueries.ltAll(0, subquery));页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/27048239
复制相关文章
相似问题
腾讯云开发者
