Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

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

@Override
public String getBioDataNameByEmpDataId(Long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("id", id));
    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    return (String) criteria.setProjection(Projections.property("bioData.firstName")).uniqueResult();
}

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();
}

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

@Override
public List<Integer> getAllGender() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setProjection(Projections.property("name"));
    return criteria.list();
}

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

@Override
public List<Integer> getAllModelReferensiId() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setProjection(Projections.property("modelReffernsil"));
    return criteria.list();
}

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

@Override
public Integer getLastOrderScala(Long systemScoringId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("systemScoring.id", systemScoringId));
    criteria.addOrder(Order.desc("orderScala"));
    return (Integer) criteria.setProjection(Projections.property("orderScala")).setMaxResults(1).uniqueResult();
}

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

@Override
public String getWtHolidayNameByName(String name) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("holidayName", name));
    return (String) criteria.setProjection(Projections.property("holidayName")).uniqueResult();
}

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

@Override
public List<WtPeriode> getAllYears() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setProjection(Projections.distinct(Projections.property("tahun")));
    //        criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria.list();
}

From source file:com.ipn.escom.ageinnn.alumno.service.AlumnoServiceImpl.java

@SuppressWarnings("unchecked")
public List<Grupo> findAllByAlumno(Alumno alumno) {
    List<Grupo> grupoList;/*  www  .j ava  2  s  . co  m*/
    setSession(Service.getSessionFactory().getCurrentSession());
    this.session.beginTransaction();
    grupoList = session.createCriteria(Inscripcion.class).add(Restrictions.eq("alumnoId", alumno.getId()))
            .setProjection(Projections.property("grupo")).list();

    session.getTransaction().commit();
    return grupoList;
}

From source file:com.ipn.escom.ageinnn.usuario.service.AspiranteServceImpl.java

public List<String> findAllFolios(PeriodoAdmision periodo) {
    List<String> folios = new ArrayList<>();
    try {//from www. j  a va  2  s  . com
        session = Service.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        folios = session.createCriteria(MedicoResidente.class).add(Restrictions.isNotNull("folio"))
                .setProjection(Projections.property("folio")).list();
        session.getTransaction().commit();
    } catch (Exception e) {
        session.getTransaction().rollback();
        throw e;
    }
    return folios;
}

From source file:com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.java

License:Open Source License

@SuppressWarnings({ "unchecked" })
@Transactional(propagation = Propagation.REQUIRED)
public List<String> getAllSubTenantIdList(ExecutionContext context, final String parentTenantId) {
    List<String> subTenantIdList = new ArrayList<String>();

    /* Retrieving parent tenant. */
    RepoTenant parent = getRepoTenant(parentTenantId, false);

    if (parent != null) {
        DetachedCriteria criteria = createSubTenantsCriteria(parent, null, -1);
        criteria.getExecutableCriteria(getSession()).setCacheable(true);
        criteria.setProjection(Projections.property("tenantId"));
        subTenantIdList.addAll(getHibernateTemplate().findByCriteria(criteria));
    }/*  www .j  av a2s .com*/

    return subTenantIdList;
}