Example usage for org.hibernate.criterion Subqueries propertiesNotIn

Introduction

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

Prototype

public static Criterion propertiesNotIn(String[] propertyNames, DetachedCriteria dc) 

Source Link

Document

Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result.

Usage

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

@Override
public List<EmpData> getListEmpDataWhichNotExistOnFingerEmpMatch() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    DetachedCriteria fingerMatchEmpCriteria = DetachedCriteria.forClass(FingerMatchEmp.class)
            .createAlias("empData", "empData", JoinType.INNER_JOIN)
            .setProjection(Projections.property("empData.id"));

    String[] propertyEmpDataId = { "id" };
    criteria.add(Subqueries.propertiesNotIn(propertyEmpDataId, fingerMatchEmpCriteria))
            .setFetchMode("bioData", FetchMode.JOIN).setFetchMode("jabatanByJabatanId", FetchMode.JOIN);
    return criteria.list();
}

---