About DESC

21-30 of 41Refresh
Forum
3

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 ... .createQuery(             "SELECT i FROM Invoice i ORDER BY i.getPrice() DESC");         List resultList ... (); Query query = em.createQuery( "SELECT i FROM Invoice i ORDER BY i.getPrice() desc
Forum
3

Strange behaviour with ORDER BY and IN

l from Location l order by l.id desc", Location.class)             .getResultList().forEach(l ... Location l where l.id IN :ids order by l.id desc", Location.class)             .setParameter("ids ... .createQuery("select l from Location l where l.town IN :towns order by l.town desc", Location.class
Forum
3

First query takes 4+ minutes to complete

RecordingMetaData AS r ORDER BY r.startDate DESC, r.startTime DESC, r.channelNumber DESC We limit
Forum
3

Navigation through Path to evaluate collection

.sku DESC"        ,ProductData.class)        .setParameter("key", key)        .setParameter("id ... item.identifier id WHERE item.sku = :key OR id = :id ORDER BY item.sku DESC You may also try ... = :key OR item.apiId.identifier = :id ORDER BY item.sku DESC lo
Forum
3

Wrong data stored in time only fields

from DateTime AS r ORDER BY r.startDate DESC, r.startTime DESC");         resultList = q ... .createQuery("SELECT r from DateTime AS r ORDER BY r.startDateTime DESC");         resultList = q
Forum
2

JPQL IN Operator

.creationtime DESC"), this seems to work in ObjectDB, but fails with EclipseLink .. I really need ... by dv.creationtime DESC], line 1, column 98: unexpected token [:capabilities].   This is not
Issue
2

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
Issue
2

Sort of very large objects - out of memory

the following using indexes: SELECT m FROM Message m ORDER by priority DESC, createTime ... indexes with different ASC / DESC components will be supported in future versions
Forum
2

Sorting problem

BY ?1 DESC";     icQuery = em.createQuery(q, Branch.class);     icQuery.setParameter(1, "br.id ... Branch br ORDER BY br.id DESC"; icQuery = em.createQuery(q, Branch.class); The problem
Forum
2

String Contains Query Result - Possible?

within the System Description. public static Program programByDescription(String desc) { for(Program p : allPrograms()) if(desc.contains(p.getDescription())) return p; return null