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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.asc()
Create an ordering by the ascending value of the expression. @param x expression used to define the ordering @return ascending ordering corresponding to the expression

        Root<User> c = cq.from(User.class);
        Predicate condition = cb.equal(c.get("deleted"), false);
        cq.where(condition);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {
          cq.orderBy(cb.desc(c.get(orderby)));
        }
        TypedQuery<User> q = em.createQuery(cq);
        q.setFirstResult(start);

View Full Code Here

            // Build the Query
            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
            Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
            cq.where(cb.equal(gradedEventRoot.get("course"), course));
            cq.orderBy(cb.asc(gradedEventRoot.get("assignment")),
                    cb.asc(gradedEventRoot.get("version")));
            TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


            // Run the query and return the resulting list of Graded Events
            return gradedEventQuery.getResultList();

View Full Code Here

            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
            Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
            cq.where(cb.equal(gradedEventRoot.get("course"), course));
            cq.orderBy(cb.asc(gradedEventRoot.get("assignment")),
                    cb.asc(gradedEventRoot.get("version")));
            TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


            // Run the query and return the resulting list of Graded Events
            return gradedEventQuery.getResultList();
        }

View Full Code Here

            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
            Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
            cq.where(cb.and(cb.equal(gradedEventRoot.get("course"), course),
                    cb.equal(gradedEventRoot.get("term"), term)));
            cq.orderBy(cb.asc(gradedEventRoot.get("assignment")),
                    cb.asc(gradedEventRoot.get("version")));
            TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


            // Run the query and return the resulting list of Graded Events
            return gradedEventQuery.getResultList();

View Full Code Here

            CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
            Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
            cq.where(cb.and(cb.equal(gradedEventRoot.get("course"), course),
                    cb.equal(gradedEventRoot.get("term"), term)));
            cq.orderBy(cb.asc(gradedEventRoot.get("assignment")),
                    cb.asc(gradedEventRoot.get("version")));
            TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


            // Run the query and return the resulting list of Graded Events
            return gradedEventQuery.getResultList();
        }

View Full Code Here


        // Build the Query
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
        Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
        cq.orderBy(cb.asc(gradedEventRoot.get("course").get("name")),
                cb.asc(gradedEventRoot.get("assignment")),
                cb.asc(gradedEventRoot.get("version")));
        TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


        // Run the query and return the resulting list of Graded Events

View Full Code Here

        // Build the Query
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
        Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
        cq.orderBy(cb.asc(gradedEventRoot.get("course").get("name")),
                cb.asc(gradedEventRoot.get("assignment")),
                cb.asc(gradedEventRoot.get("version")));
        TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


        // Run the query and return the resulting list of Graded Events
        return gradedEventQuery.getResultList();

View Full Code Here

        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<GradedEvent> cq = cb.createQuery(GradedEvent.class);
        Root<GradedEvent> gradedEventRoot = cq.from(GradedEvent.class);
        cq.orderBy(cb.asc(gradedEventRoot.get("course").get("name")),
                cb.asc(gradedEventRoot.get("assignment")),
                cb.asc(gradedEventRoot.get("version")));
        TypedQuery<GradedEvent> gradedEventQuery = em.createQuery(cq);


        // Run the query and return the resulting list of Graded Events
        return gradedEventQuery.getResultList();

View Full Code Here

            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<Question> cq = cb.createQuery(Question.class);
            Root<Question> questionRoot = cq.from(Question.class);
            // Restrict result to those not found in the list of Question Id's
            cq.where(cb.not(questionRoot.get("id").in(questionIds)));
            cq.orderBy(cb.asc(questionRoot.get("name")));
            TypedQuery<Question> questionQuery = em.createQuery(cq);
            try
            {
                LOGGER.debug("Getting list of Questions");
                List<Question> result = questionQuery.getResultList();

View Full Code Here

            // EntityManager and Query object creation done above once this is
            // clear.
            cb = em.getCriteriaBuilder();
            CriteriaQuery<Question> cqQuest = cb.createQuery(Question.class);
            Root<Question> questionRoot = cqQuest.from(Question.class);
            cqQuest.orderBy(cb.asc(questionRoot.get("name")));
            TypedQuery<Question> questionQuery = em.createQuery(cqQuest);
            List<Question> questionResult;
            try
            {
                count = 0;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.