Examples of javax.persistence.criteria.CriteriaBuilder.max()

Class javax.persistence.criteria.CriteriaBuilder

Examples of javax.persistence.criteria.CriteriaBuilder.max()

javax.persistence.criteria.CriteriaBuilder.max()
Create an aggregate expression applying the numerical max operation. @param x expression representing input value to max operation @return max expression

        Root<AggEntity> aer = cq.from(AggEntity.class);
        Path<T> path = aer.get(sa);
        Expression<T> exp = null;
        switch (at) {
        case MAX:
            exp = cb.max(path);
            break;
        case MIN:
            exp = cb.min(path);
            break;
        case SUM:

View Full Code Here

        Root<Serializable> original = criteria.from(ceilingClass);
        
        if (isCount) {
            criteria.select(criteriaBuilder.count(original));
        } else if (isMax) {
            criteria.select(criteriaBuilder.max((Path<Number>) ((Object) original.get(maxField))));
        } else {
            criteria.select(original);
        }


        List<Predicate> restrictions = new ArrayList<Predicate>();

View Full Code Here

            Root<JPACommit> from = query.from(JPACommit.class);
            query.select(from);


            Subquery<Number> subquery = query.subquery(Number.class);
            Root maxTime = subquery.from(JPACommit.class);
            subquery.select(criteriaBuilder.max(maxTime.get("timestamp")));
            subquery.where(criteriaBuilder.le(maxTime.get("timestamp"), timestamp));


            query.where(criteriaBuilder.equal(from.get("timestamp"), subquery));


            TypedQuery<JPACommit> typedQuery = entityManager.createQuery(query);

View Full Code Here


            query.select(from);


            Subquery<Number> subquery = query.subquery(Number.class);
            Root maxTime = subquery.from(JPAObject.class);
            subquery.select(criteriaBuilder.max(maxTime.get("timestamp")));
            Predicate subPredicate1 = criteriaBuilder.le(maxTime.get("timestamp"), timestamp);
            Predicate subPredicate2 = criteriaBuilder.equal(maxTime.get("oid"), from.get("oid"));
            subquery.where(criteriaBuilder.and(subPredicate1, subPredicate2));


            Predicate predicate1 = criteriaBuilder.equal(from.get("timestamp"), subquery);

View Full Code Here


            query.select(from);


            Subquery<Number> subquery = query.subquery(Number.class);
            Root maxTime = subquery.from(JPAObject.class);
            subquery.select(criteriaBuilder.max(maxTime.get("timestamp")));
            subquery.where(criteriaBuilder.equal(from.get("oid"), maxTime.get("oid")));


            Predicate predicate1 = criteriaBuilder.in(from.get("oid")).value(oid);
            Predicate predicate2 = criteriaBuilder.equal(from.get("timestamp"), subquery);

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.