Package javax.persistence.criteria

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

95
96
97
98
99
100
101
102
103
104
105
        }
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<UserHD> z = cq.from(UserHD.class);
        cq.where(cb.equal(z.get(UserHD_.organization), o));
        cq.orderBy(cb.asc(z.get(UserHD_.name)));
        cq.select(z);
       
        return getEntityManager().createQuery(cq).getResultList();
       
    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
   
    public List<Priority> findAll() {
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<Priority> h = cq.from(Priority.class);
        cq.orderBy(cb.asc(h.get(Priority_.id)));
        return getEntityManager().createQuery(cq).getResultList();
    }

  
  
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
        CriteriaQuery cq = cb.createQuery();
        Root<ServiceObject> s = cq.from(ServiceObject.class);
       
        cq.where(cb.equal(s.get(ServiceObject_.organization), curUser.getOrganization()));
       
        cq.orderBy(cb.asc(s.get(ServiceObject_.id)));
        cq.select(s);
       
        return getEntityManager().createQuery(cq).getResultList();

       
View Full Code Here
574
575
576
577
578
579
580
581
582
583
584
            {
                criteriaQuery.where((value != null) ? criteriaBuilder.equal(beanRoot.get(name), value) : criteriaBuilder.isNull(beanRoot.get(name)));
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
638
639
640
641
642
643
644
645
646
647
648
                }
                criteriaQuery.where(predicate);
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
        Root<Inventory> inv = q.from(Inventory.class);
        q.select(inv);
        Expression<Integer> inStock = cb.diff(
                inv.get(Inventory_.supplied),
                inv.get(Inventory_.sold));
        q.orderBy(cb.asc(inStock));
       
        List<Inventory> result = em.createQuery(q)
                                   .setMaxResults(limit)
                                   .getResultList();
        commit();
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
            switch (constraint.getColumnSort())
            {

                case ASCENDING:

                    criteria.orderBy(builder.asc(propertyPath));
                    break;

                case DESCENDING:
                    criteria.orderBy(builder.desc(propertyPath));
                    break;
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        // }
        SortOrderItem item = iter.next();
        Path<?> path = root.get(mt.getSingularAttribute(item.getProperty()));
        Direction direction = item.getDirection();
        if (direction == Direction.ASC) {
          orderList.add(cb.asc(path));
        } else if (direction == Direction.DESC) {
          orderList.add(cb.desc(path));
        } else if (direction == Direction.ASC_TRUNC) {
          orderList.add(cb.asc(cb.function("trunc", Path.class, path)));
        } else if (direction == Direction.DESC_TRUNC) {
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        if (direction == Direction.ASC) {
          orderList.add(cb.asc(path));
        } else if (direction == Direction.DESC) {
          orderList.add(cb.desc(path));
        } else if (direction == Direction.ASC_TRUNC) {
          orderList.add(cb.asc(cb.function("trunc", Path.class, path)));
        } else if (direction == Direction.DESC_TRUNC) {
          orderList.add(cb.desc(cb.function("trunc", Path.class, path)));
        }
      }
      cq.orderBy(orderList);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
      ArrayList<Order> order = new ArrayList<Order>();
      while (iter.hasNext()) {
        Entry<String, Direction> entry = iter.next();
        Path<?> path = evsr.get(mt.getSingularAttribute(entry.getKey()));
        if (entry.getValue() == Direction.ASC) {
          order.add(cb.asc(path));
        } else if (entry.getValue() == Direction.DESC) {
          order.add(cb.desc(path));
        }
      }
      cq.orderBy(order);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.