About orderBy

11-20 of 23Refresh
JPA Doc
9

javax.persistence.criteria.CriteriaQuery

item has the same assigned alias Since: JPA 2.0 CriteriaQuery orderBy(List o) Specify ... of zero or more ordering expressions Returns: the modified query Since: JPA 2.0 CriteriaQuery orderBy
Forum
4

How to convert a boolean to an int in the query?

(intCaptial);         q.orderBy(cb.asc(intCaptial));         query = em.createQuery(q ... ); q.orderBy(cb.asc(intApproveEmail)); query = em.createQuery(q); resultList ... .orderBy(cb.desc(cb.sum(intApproveEmail, intApprovePhoneNumber))); query = em.createQuery(q
Issue
4

Strange Error with Criteria API and Sorting

.Join; import javax.persistence.criteria.Root; public class Test_OrderBy { public static void ... ("other");   query.orderBy(cb.asc(cb.upper((Expression) (Expression) otherJoin.get("name ... .java:695) at Test_OrderBy.main(Test_OrderBy.java:45) Caused by: com.objectdb.o.UserException
Forum
3

Activation error on Schema change

Hi, Is @OrderBy annotation supported ? When I add this annotation to my entity I get an error, saying that I did not activate my ObjectDB (which I did) : Caused by: com.objectdb.o ... .   Greetings, Karol Borkowski This is probably not related particularly to @OrderBy, and actually any change
Issue
3

NPE at com.objectdb.jpa.JpaQuery.getResultList

(MomentPayload.class); query.select(fromMomentPayload); query.orderBy(cb.desc ... (MomentPayload.class);             query.select(fromMomentPayload);             query.orderBy(cb.desc
Forum
2

@OrderColumn issue

tables and therefore does not handle columns. However, you can use use the OrderBy annotation
Issue
2

Alias not used in ORDER BY

Hi, I am doing something simple like final Root from = criteria.from(T.class) final Path path = from.get("someStringProperty") final Expression upperPath = builder.upper((Expression) path); upperPath.alias("TEST"); criteria.multiselect(from, path); criteria.orderBy
Forum
2

Error during cascaded merge

= "unit", cascade = CascadeType.ALL, orphanRemoval = true, fetch = FetchType.EAGER)     @OrderBy
Forum
2

In version 2.5.2_05 does not work greatest by Date

In earlier versions this query worked fine. In version 2.5.2_05 does not work .orderBy(cb.desc(cb.greatest(root.get("createDate").as(Date.class)))).distinct(true) Thank you for your help. Please try build 2.5.2_06 that should fix this regression (of casting to Date). galandor
Forum
2

Problem persisting a TreeSet field

as List and use the @OrderBy annotation to refine the automatic query to return ordered elements