ProjectionList p = Projections.projectionList().create();
p.add(Projections.property("subMoeda.observacao"), "observacao");
subQuery.setProjection(p);
subQuery.add(Expression.eq("subMoeda.id", 7L));
Criteria criteria = getSession().createCriteria(Moeda.class, "moeda");
ProjectionList p2 = Projections.projectionList().create();
p2.add(Projections.property("moeda.observacao"), "observacao");
p2.add(Projections.property("moeda.nome"), "nome");
p2.add(Projections.property("moeda.cifra"), "cifra");
criteria.setProjection(p2);
criteria.add(Property.forName("moeda.nome").eq(subQuery));
criteria.setResultTransformer(new AliasToBeanResultTransformer(Moeda.class));
Collection
CONSOLE:
select
this_.observacao as y0_,
this_.nome as y1_,
this_.cifra as y2_
from
Moeda this_
where
this_.nome = (
select
this0__.observacao as y0_
from
Moeda this0__
where
this0__.id=?
)
Nenhum comentário:
Postar um comentário