Example usage for org.hibernate.criterion Projections groupProperty

Introduction

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

Prototype

public static PropertyProjection groupProperty(String propertyName)

Source Link

Document

A grouping property value projection

Usage

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

@SuppressWarnings("unchecked")
public List<Curso> findAllCursoByPeriodo(Class<Curso> aClass, PeriodoAdmision periodoAdmision) {
    List<Curso> cursoList = new ArrayList<>();
    GrupoService grupoService = new GrupoService();

    session = Service.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from   w ww .ja v a  2 s. c  om*/

    cursoList = session.createCriteria(Grupo.class)
            .add(Restrictions.eq("periodoAdmisionId", periodoAdmision.getId()))
            .setProjection(Projections.groupProperty("curso")).list();

    System.out.println("Curso : " + cursoList);

    session.getTransaction().commit();

    return cursoList;
}

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

License:Open Source License

public Map<String, Integer> getSubTenantsCountMap(List<String> tenantIds) {
    if (tenantIds == null || tenantIds.size() == 0) {
        return Collections.emptyMap();
    }//  w  w  w .  j a v  a  2  s  . c om

    DetachedCriteria criteria = DetachedCriteria.forClass(persistentTenantClass());

    criteria.createAlias("parent", "p");
    criteria.add(Restrictions.in("p.tenantId", tenantIds));

    criteria.setProjection(Projections.projectionList().add(Projections.rowCount())
            .add(Projections.groupProperty("p.tenantId")));
    criteria.getExecutableCriteria(getSession()).setCacheable(true);

    List results = getHibernateTemplate().findByCriteria(criteria);

    Map<String, Integer> subTenantCounts = new HashMap<String, Integer>(tenantIds.size(), 1);
    if (results != null && results.size() > 0) {
        for (Object result : results) {
            String tenantId = (String) ((Object[]) result)[1];
            Integer count = (Integer) ((Object[]) result)[0];

            subTenantCounts.put(tenantId, count);
        }
    }

    for (String tenantId : tenantIds) {
        if (!subTenantCounts.containsKey(tenantId)) {
            subTenantCounts.put(tenantId, 0);
        }
    }

    return subTenantCounts;
}

From source file:com.jaspersoft.jasperserver.search.sorter.ByAccessTimeSorter.java

License:Open Source License

@Override
protected void addProjection(String type, ExecutionContext context, SearchCriteria criteria) {
    String alias = criteria.getAlias("accessEvents", "ae");
    criteria.addProjection(Projections.projectionList().add(Projections.max(alias + ".eventDate"), "aed")
            .add(Projections.groupProperty("accessEvents")));

    criteria.addOrder(Order.desc("aed"));
}

From source file:com.jaspersoft.jasperserver.search.sorter.ByPopularitySorter.java

License:Open Source License

@Override
protected void addProjection(String type, ExecutionContext context, SearchCriteria criteria) {
    criteria.addProjection(Projections.projectionList().add(Projections.count("accessEvents"), "aec")
            .add(Projections.groupProperty("accessEvents")));

    criteria.addOrder(Order.desc("aec")).addOrder(Order.asc("id"));
}

From source file:com.kodemore.hibernate.criteria.KmCriteria.java

License:Open Source License

public void groupBy(String name) {
    Projection e;
    e = Projections.groupProperty(getFullName(name));
    addProjection(e);
}

From source file:com.liferay.portal.dao.orm.hibernate.ProjectionFactoryImpl.java

License:Open Source License

public Projection groupProperty(String propertyName) {
    return new ProjectionImpl(Projections.groupProperty(propertyName));
}

From source file:com.liferay.portal.workflow.jbpm.dao.CustomSession.java

License:Open Source License

public List<ProcessDefinition> findProcessDefinitions(String name, boolean latest, int start, int end,
        OrderByComparator orderByComparator) {

    try {//from w ww. j ava 2s .c o m
        Criteria criteria = _session.createCriteria(ProcessDefinition.class);

        if (latest) {
            ProjectionList projectionList = Projections.projectionList();

            projectionList.add(Projections.groupProperty("name"));
            projectionList.add(Projections.max("version"));

            criteria.setProjection(projectionList);

            addOrder(criteria, orderByComparator, "version");
        }

        if (name != null) {
            criteria.add(Restrictions.eq("name", name));

            addOrder(criteria, orderByComparator, "name");
        }

        if (latest == false && name == null) {
            addOrder(criteria, orderByComparator);
        }

        addPagination(criteria, start, end);

        if (latest) {
            List<Object[]> list = criteria.list();

            List<String> names = new ArrayList<String>(list.size());

            for (Object[] array : list) {
                names.add((String) array[0]);
            }

            return findProcessDefinitions(names);
        } else {
            return criteria.list();
        }
    } catch (Exception e) {
        throw new JbpmException(e);
    }
}

From source file:com.metropolitan.formulasport727.dao.KorpaArtikalDAOImpl.java

@Override
public List<KorpaArtikal> getListaSvihJedinstvenihKorpaArtikalaKorpe(Korpa korpa) {
    return session.createCriteria(KorpaArtikal.class).add(Restrictions.eq("korId", korpa))
            .setProjection(Projections.projectionList().add(Projections.property("id").as("id"))
                    .add(Projections.property("korId").as("korId"))
                    .add(Projections.groupProperty("artId").as("artId")))
            .setResultTransformer(Transformers.aliasToBean(KorpaArtikal.class)).list();
}

From source file:com.myimage.business.ProfileImpl.java

@Override
public Properties profileActives() {

    List<Object> objects = null;
    Properties prop = new Properties();
    Criteria criteria = this.session.createCriteria(User.class);
    criteria.setProjection(//  ww w .  j  ava 2 s .c  o  m
            Projections.projectionList().add(Projections.rowCount()).add(Projections.groupProperty("active")));

    objects = criteria.list();

    for (Object o : objects) {
        Object[] objArr = (Object[]) o;
        // chave: active, valor: quantidade
        prop.setProperty(objArr[1].toString(), objArr[0].toString());
    }
    return prop;
}

From source file:com.myimage.model.dao.ProfileDaoImpl.java

public Properties profileActives() {
    List<Object> objects = null;
    Properties prop = new Properties();
    Criteria criteria = this.session.createCriteria(User.class);
    criteria.setProjection(/*from ww w.  ja  va 2 s.c o m*/
            Projections.projectionList().add(Projections.rowCount()).add(Projections.groupProperty("active")));

    objects = criteria.list();

    for (Object o : objects) {
        Object[] objArr = (Object[]) o;
        // chave: active, valor: quantidade
        prop.setProperty(objArr[1].toString(), objArr[0].toString());
    }
    return prop;
}