About ORDER BY

11-20 of 200Refresh
Issue
45

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
38

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
38

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
37

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
37

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
JPA Doc
37

isAscending()

Method javax.persistence.criteria.Order boolean isAscending() Whether ascending ordering is in effect. Returns: boolean indicating whether ordering is ascending Since: JPA 2.0
JDO Doc
37

Order.column

Annotation Element javax.jdo.annotations.Order String column The name of the column to use for ordering the elements of the member. Returns: the name of the ordering column Default value: "" Since: JDO 2.1
JDO Doc
37

Order.columns

Annotation Element javax.jdo.annotations.Order Column[] columns The definition of the column(s) to use for ordering. Returns: the columns to use for ordering Default value: {} Since: JDO 2.1
JDO Doc
37

Order.mappedBy

Annotation Element javax.jdo.annotations.Order String mappedBy Name of a field or property in the target class that acts as the ordering field or property for this member. Return the name of the field or property in the target class Default value: "" Since: JDO 2.1
Issue
25

Collation and String Order

will affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by Unicode order, and a workaround that enables controlling the order is to use normalizing, as discussed ... , DMS and other systems requires correct collation when using order by clause.  +1 for this ... lwalkowski dmarko Arne