Home » Search

About ORDER BY

11-20 of 200Refresh
Forum
28

ORDER BY problem, when String starts with language specific character

Dear all, I have a problem with ORDER BY clause. I have a simple query: select u from User u order by u.name When the name starts with "normal/english" character, records are ordered correctly ... to JPQL and JDOQL) you can use the Normalizer expression directly in the query ORDER BY clause
Manual
28

Database Explorer

the order of the shown fields by using the Up and Down arrow buttons or the [Field Ordering] combo ... directory a path to it has to be specified. Alternatively, you can run the Explorer by double clicking explorer.jar or by running explorer.exe (on Windows) or explorer.sh (on Unix/Linux, after editing
Forum
28

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

Hi, I have found an issue in ordering by a method. I have two entities : Invoice and InvoiceItem ... ...) 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
Forum
27

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 ... Hi Anyone could help me I need to order a string  for example user1, user2, ..., user1000 I found
Forum
27

NULL prefered in ORDER BY?

Hi! Is there a way to NOT prefer NULL in Order BY? I.e. assume this: @Entity class Hint ... Test ORDER BY hint.name It orders ASC like this (assuming I've got three Test Entities whereas first ... are smaller than any other value so they appear first in ordering. Please fill a feature request
Issue
27

Alias not used in ORDER BY

(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY TEST However what I actually get as query string is SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY UPPER($1
JPA Doc
25

javax.persistence.criteria.Order

javax.persistence.criteria Interface Order An object that defines an ordering over the query results. Since: JPA 2.0 Learn how to use JPA Criteria API's Order in Chapter 4 of the ObjectDB/JPA manual. Expression getExpression() Return the expression that is used for ordering. Return
JDO Doc
25

javax.jdo.annotations.Order

javax.jdo.annotations Annotation Order Target: Fields (including property get methods) Annotation for the ordering component of an ordered container member, such as Java Collections Framework Array and List types and Java native array types. Corresponds to the xml element "order". Since: JDO 2.1
JPA Doc
24

reverse()

Method javax.persistence.criteria.Order Order reverse() Switch the ordering. Returns: a new Order instance with the reversed ordering Since: JPA 2.0
JPA Doc
24

getExpression()

Method javax.persistence.criteria.Order Expression getExpression() Return the expression that is used for ordering. Returns: expression used for ordering Since: JPA 2.0