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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.lessThan()
Create a predicate for testing whether the first argument is less than the second. @param x expression @param y expression @return less-than predicate

        assertEquals(N_ORDERS / 2, typedJpqlResults.size());


        CriteriaBuilder qb = em.getCriteriaBuilder();
        CriteriaQuery<Order> criteriaQuery = qb.createQuery(Order.class);
        Root<Order> order = criteriaQuery.from(Order.class);
        criteriaQuery.select(order).where(qb.lessThan(order.get(Order_.date), qb.parameter(Date.class, "maxDate")));
        TypedQuery<Order> tq = em.createQuery(criteriaQuery);
        tq.setParameter("maxDate", maxDate);
        List<Order> criteriaResults = tq.getResultList();
        assertEquals(N_ORDERS / 2, criteriaResults.size());

View Full Code Here

        }


        if (criteria.getToDate() != null) {
            predicate = builder.and(
                    predicate,
                    builder.lessThan(
                            _order.get(Order_.creationTime),
                            criteria.getToDate().plusDays(1).toDateTimeAtStartOfDay()));
        }


        if (!criteria.getSides().isEmpty()) {

View Full Code Here

        }


        if (criteria.getToDate() != null) {
            predicate = builder.and(
                    predicate,
                    builder.lessThan(
                            _transaction.get(Transaction_.creationTime),
                            criteria.getToDate().plusDays(1).toDateTimeAtStartOfDay()));
        }


        // Assign predicate to where clause

View Full Code Here

        assertEquals(N_ORDERS / 2, typedJpqlResults.size());


        CriteriaBuilder qb = em.getCriteriaBuilder();
        CriteriaQuery<Order> criteriaQuery = qb.createQuery(Order.class);
        Root<Order> order = criteriaQuery.from(Order.class);
        criteriaQuery.select(order).where(qb.lessThan(order.get(Order_.date), qb.parameter(Date.class, "maxDate")));
        TypedQuery<Order> tq = em.createQuery(criteriaQuery);
        tq.setParameter("maxDate", maxDate);
        List<Order> criteriaResults = tq.getResultList();
        assertEquals(N_ORDERS / 2, criteriaResults.size());

View Full Code Here

                }
                
                Predicate minRange = builder.greaterThan(pathToUse.get(key).as(BigDecimal.class), min);
                Predicate maxRange = null;
                if (max != null) {
                    maxRange = builder.lessThan(pathToUse.get(key).as(BigDecimal.class), max);
                    rangeRestrictions.add(builder.and(minRange, maxRange));
                } else {
                    rangeRestrictions.add(minRange);
                }
            }

View Full Code Here

        restrictions.add(builder.or(
                            builder.isNull(product.get("archiveStatus").get("archived")),
                            builder.equal(product.get("archiveStatus").get("archived"), 'N')));
        
        // Add the active start/end date restrictions
        restrictions.add(builder.lessThan(sku.get("activeStartDate").as(Date.class), currentDate));
        restrictions.add(builder.or(
                            builder.isNull(sku.get("activeEndDate")),
                builder.greaterThan(sku.get("activeEndDate").as(Date.class), currentDate)));
    }

View Full Code Here

                restrictions.add(builder.or(builder.isNull(root.get("deactivated")),
                        builder.isFalse(root.get("deactivated").as(Boolean.class))));
            }
        }
        if (dateCreatedMinThreshold != null) {
            restrictions.add(builder.lessThan(root.get("auditable").get("dateCreated").as(Date.class), dateCreatedMinThreshold));
        }
        if (isPreview != null) {
            if (isPreview) {
                restrictions.add(builder.isTrue(root.get("previewable").get("isPreview").as(Boolean.class)));
            } else {

View Full Code Here

        restrictions.add(root.get("status").in(statusList));
        if (names != null) {
            restrictions.add(root.get("name").in(Arrays.asList(names)));
        }
        if (dateCreatedMinThreshold != null) {
            restrictions.add(builder.lessThan(root.get("auditable").get("dateCreated").as(Date.class), dateCreatedMinThreshold));
        }
        if (isPreview != null) {
            if (isPreview) {
                restrictions.add(builder.isTrue(root.get("previewable").get("isPreview").as(Boolean.class)));
            } else {

View Full Code Here

        if (start != null) {
            Predicate after = builder.greaterThanOrEqualTo(activity.<Date>get(AT), start);
            where = builder.and(where, after);
        }
        if (end != null) {
            Predicate before = builder.lessThan(activity.<Date>get(AT), end);
            where = builder.and(where, before);
        }
        cq.where(where);
        cq.orderBy(builder.desc(activity.get(AT)));
        return em().createQuery(cq).getResultList();

View Full Code Here

            if (start != null) {
                Predicate after = builder.greaterThanOrEqualTo(activity.<Date>get(AT), start);
                where = builder.and(where, after);
            }
            if (end != null) {
                Predicate before = builder.lessThan(activity.<Date>get(AT), end);
                where = builder.and(where, before);
            }
            where = builder.and(where, builder.le(activity.<Integer>get(LEVEL), 2));
            cq.where(where);
            cq.orderBy(builder.desc(activity.get(AT)));

View Full Code Here

0 1

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.