Home » Search

About ASC

11-20 of 24Refresh
Forum
5

Listing large number of complicated objects with paging.

with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 ... .createQuery("select prod from Product prod order by prod.id ASC", Product.class); prodList = icQuery ... Product prod order by prod.id ASC] 2011-11-15 19:30:59.578 [http-bio-8080-exec-3] DEBUG pl.hplxtool.dao
Forum
4

Cannot sort descending, when ordering by caluculated float in a method

...) select i from Invoice i order by i.getPrice() desc/asc it gives the same order for desc and asc (every time asc) When the float is not calculated (only returned), the ordering works correctly. Michael EDIT: I have found out, that ordering doesn't work in this case at all - it was only a luck, that asc
Forum
4

Problem with distinct select, order by and equivalent alias/attribute path

_location "             + "order by s_location.id asc";         System.out.println("Working query ... "             + "left join s.location as s_location "             + "order by s.location.id asc ... "             + "order by s_location.id asc";         System.out.println("\nNOT working: ");         System.out.println
Forum
3

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
Forum
3

NULL prefered in ORDER BY?

Test ORDER BY hint.name It orders ASC like this (assuming I've got three Test Entities whereas first ... for ASC (because it simply makes more sense) is: Test 1 (with hint = A) Test 2 (with hint = B
Forum
3

order by string with numbers

  The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM Users u ORDER BY SUBSTRING(u.username,4)*1 ASC If you have other alternative for JPA
Issue
2

Alias not used in ORDER BY

(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause
Forum
2

Attempt to open a non existing file '/tmp/objectdb_xxxx/SortQueryItr_6.mrg'

bk ORDER BY bk.time ASC", OBN); ) 2/ after a little while - some of the applications throw
Forum
2

Grouping by date()

), count(ov) from ObjectView ov group by hour(ov.created) order by hour(ov.created) ASC where ov
Forum
2

JPQL IN Operator

>= :earliest and dv.creationtime <= :latest order by dv.creationtime ASC [ObjectDB 2.2.9] javax