Example usage for org.hibernate.criterion Projections id

Introduction

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

Prototype

public static IdentifierProjection id()

Source Link

Document

An identifier value projection.

Usage

From source file:com.jaspersoft.jasperserver.search.filter.ScheduleFilter.java

License:Open Source License

private void createCriteria(SearchCriteria criteria, User user, boolean scheduled, boolean scheduledByUser) {
    SearchCriteria uriCriteria = SearchCriteria.forClass(PersistentReportJob.class);
    if (scheduledByUser) {
        addOwnerCriteria(uriCriteria, user);
    }/*  w  w  w.  j av  a 2s  . com*/
    uriCriteria.addProjection(Projections.property("source.reportUnitURI"));
    List uriList = getHibernateTemplate().findByCriteria(uriCriteria);

    if (!uriList.isEmpty()) {
        SearchCriteria idCriteria = SearchCriteria.forClass(RepoResource.class);
        Disjunction disjunction = Restrictions.disjunction();
        String alias = idCriteria.getAlias("parent", "p");
        for (Object o : uriList) {
            String uri = (String) o;

            disjunction.add(getResourceCriterion(alias, uri));
        }

        idCriteria.add(disjunction);
        idCriteria.addProjection(Projections.id());

        List idList = getHibernateTemplate().findByCriteria(idCriteria);

        if (!idList.isEmpty()) {
            if (scheduled) {
                criteria.add(Restrictions.in("id", idList));
            } else {
                criteria.add(Restrictions.not(Restrictions.in("id", idList)));
            }
        } else {
            throw new RuntimeException("No resources found for URI list " + uriList);
        }
    } else {
        if (scheduled || scheduledByUser) {
            criteria.add(Restrictions.isNull("id"));
        }
    }
}

From source file:com.jpizarro.th.server.generic.model.persistence.accessor.GenericAccessorHibernate.java

License:Open Source License

public boolean exists(PK id) {

    return getSession().createCriteria(entityClass).add(Restrictions.idEq(id)).setProjection(Projections.id())
            .uniqueResult() != null;

}

From source file:com.maydesk.base.table.PDPageableFactory.java

License:Mozilla Public License

public Projection getProjectionList() {
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.id(), "id");
    projectionList.add(Projections.property("cachedTitle"), "title"); // Model must be of type MBaseWithTitle!
    projectionList.add(Projections.property("cachedDescription"), "description"); // Model must be of type MBaseWithTitle!
    return Projections.distinct(projectionList);
}

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

License:Open Source License

/**
 * Creates projection which add "id" field to the "SELECT" clause.
 * // www.  j  a  va  2  s.c  o m
 * @return projection
 */
public static SearchProjection id() {
    return new SearchProjectionImpl(Projections.id());
}

From source file:com.romeikat.datamessie.core.base.query.entity.execute.AbstractEntityQueryExecutor.java

License:Open Source License

public void applyIdProjection(final Criteria criteria) {
    criteria.setProjection(Projections.id());
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public List<Integer> findIdsByUserLatestFirst(Integer userId, int maxResults) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class).add(Restrictions.eq("deleted", 0))
            .createAlias("baseUser", "u").add(Restrictions.eq("u.id", userId)).setProjection(Projections.id())
            .addOrder(Order.desc("id")).setMaxResults(maxResults);
    return criteria.list();
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public List<Integer> findIdsOverdueForUser(Integer userId, Date date) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    addUserCriteria(criteria, userId);/*from ww w  .  j  a v  a  2  s . c o m*/
    criteria.add(Restrictions.lt("dueDate", date)).createAlias("invoiceStatus", "s")
            .add(Restrictions.ne("s.id", Constants.INVOICE_STATUS_PAID)).add(Restrictions.eq("isReview", 0))
            .setProjection(Projections.id()).addOrder(Order.desc("id"));
    return criteria.list();
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public Collection<InvoiceDTO> findAllApplicableInvoicesByUser(Integer userId) {

    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    criteria.add(Restrictions.eq("baseUser.id", userId));
    criteria.add(Restrictions.eq("deleted", 0));
    criteria.add(Restrictions.eq("isReview", 0));
    criteria.setProjection(Projections.id()).addOrder(Order.desc("id"));
    return criteria.list();
}

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public List<Integer> findIdsByUserAndDate(Integer userId, Date since, Date until) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    addUserCriteria(criteria, userId);//  www . j a v a2s .c  o  m
    addPeriodCriteria(criteria, since, until);
    criteria.setProjection(Projections.id()).addOrder(Order.desc("id"));

    return criteria.list();
}

From source file:com.sapienter.jbilling.server.order.db.OrderDAS.java

License:Open Source License

public List<Integer> findIdsByUserLatestFirst(Integer userId, int maxResults) {
    Criteria criteria = getSession().createCriteria(OrderDTO.class).add(Restrictions.eq("deleted", 0))
            .createAlias("baseUserByUserId", "u").add(Restrictions.eq("u.id", userId))
            .setProjection(Projections.id()).addOrder(Order.desc("id")).setMaxResults(maxResults)
            .setComment("findIdsByUserLatestFirst " + userId + " " + maxResults);
    return criteria.list();
}