Hibernate - Adding properties of another class in Criteria Restrictions

Question

I have a table Loan application whose pojo is

class LoanApplication{
int id;
int loanNo;
...
}

I have another pojo

class LoanFlow{
int id;
int loanId;
date reviewDate;
...
}

Here loanId of loanFlow is the foreign key mapped to the id of LoanApplication.

I have to fetch all the loan applications with the reviewDate.

I am trying to write a criteria like:

Criteria criteria = getSession().createCriteria(LoanApplication.class);
criteria.add(Restrictions.eq("id", someId));

How can I fetch the reviewDate also from LoanFlow with this criteria.

Possible duplicate of [How to have criteria from multiple entities Hibernate](https://stackoverflow.com/questions/23395216/how-to-have-criteria-from-multiple-entities-hibernate) — XtremeBaumer, Sep 21 '17 at 12:28
Is there ManyToOne or OneToMany annotations to the relationship between entities? — Ady Junior, Sep 21 '17 at 12:39

score 1 · Answer 1 · answered Sep 21 '17 at 12:34

1

Criteria criteria = getSession().createCriteria(LoanApplication.class, "loApp");
criteria.createAlias("loApp.loanFlow", "flow");
criteria.add(Restrictions.eq("flow.id", 1));

You can directlly use HQL also. using createQuery()

answered Sep 21 '17 at 12:34

Sangram Badi

4,054
9
45
78

loanFlow is a separate class, it is not inside loanApplication. – Ishan Tiwary Sep 21 '17 at 12:39
But LoanApplication maped with LoanFlow – Sangram Badi Sep 21 '17 at 12:42
you can check https://stackoverflow.com/questions/8164727/how-to-implement-with-hibernate-criteria-object-the-select-query-with-inner-join – Sangram Badi Sep 21 '17 at 12:50

Ady Junior · Answer 2 · 2017-09-21T13:12:39.300

You can do it with subqueries, if there isn't ManyToOne or OneToMany annotations to the relationship between entities:

DetachedCriteria subQuery = DetachedCriteria.forClass(LoanFlow.class, "loanFlow");

/*Here there is a between, but you can change it to your necessity*/
subQuery.add(Restrictions.between("loanFlow.reviewDate", dateBegin, dateEnd));
subQuery.setProjection(Projections.property("loanFlow.loanId"));

Criteria criteria = getSession().createCriteria(LoanApplication.class, "loanApplication");        
Subqueries.propertyIn("loanApplication.id", subQuery);

List<LoanApplication> list = criteria.list();

Hibernate - Adding properties of another class in Criteria Restrictions

2 Answers2