Example usage for org.hibernate.criterion Subqueries propertyLt

Introduction

In this page you can find the example usage for org.hibernate.criterion Subqueries propertyLt.

Prototype

public static Criterion propertyLt(String propertyName, DetachedCriteria dc) 

Source Link

Document

Creates a criterion which checks that the value of a given property is less-than the value in the subquery result.

Usage

From source file:com.inkubator.hrm.dao.impl.LoanNewApplicationInstallmentDaoImpl.java

@Override
public LoanNewApplicationInstallment getLastPaidTerminInstallment(Integer LoanNewApplicationid) {

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("loanNewApplication", "loanNewApplication", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("loanNewApplication.id", LoanNewApplicationid));

    DetachedCriteria criteriaWtPeriod = DetachedCriteria.forClass(WtPeriode.class)
            .add(Restrictions.eq("payrollType", HRMConstant.PERIODE_PAYROLL_ACTIVE))
            .setProjection(Property.forName("fromPeriode"));

    criteria.add(Subqueries.propertyLt("installmentDate", criteriaWtPeriod));
    criteria.addOrder(Order.desc("numOfInstallment"));
    criteria.setMaxResults(1);/*from w ww . ja v a 2  s . c o  m*/

    LoanNewApplicationInstallment currentNextInstallment = (LoanNewApplicationInstallment) criteria
            .uniqueResult();
    return currentNextInstallment;
}

---

From source file:com.qcadoo.model.api.search.SearchSubqueries.java

License:Open Source License

public static SearchCriterion fieldLt(final String field, final SearchCriteriaBuilder criteria) {
    return new SearchCriterionImpl(
            Subqueries.propertyLt(field, ((SearchCriteria) criteria).getHibernateDetachedCriteria()));
}

---