Home » Search

About sort

1-10 of 55Refresh
Manual
74

ORDER BY clause (JPQL / Criteria API)

. The following query returns Country objects ordered by currency as the primary sort key and by name as the secondary sort key: SELECT c.currency, c.name FROM Country c ORDER BY c.currency, c.name
Manual
34

Index Definition

the BTree's primary sort key and which field is used as a secondary sort key. If x is specified first ... scan can be performed. ObjectDB also uses indexes for sorting results and for projection: SELECT ... ) thus eliminating the need for a separate sort. Finally, indexes are also used in MIN and MAX queries: SELECT
Forum
27

How the sort order (in queries) works for non english letters?

(we are Czech company). How the sort order works for international (for us 'czech') letters? Does ... normalized, if possible. Normalizing the strings only during sort is also possible, but it is less efficient ... the strings during sort).   How about support for Collation? http://download.oracle.com/javase
Forum
27

Sorting problem

with sorting. I send you a test case - sorry for using the same project as previous ... "); This query should return all the branches sorted descending, but I get this result: Branch: 100 ... value is obtained from an untrusted user). By the way, in your original query the results were sorted
Forum
26

NontransactionalWrite error using Collections.sort .

Hi, i started to use ObjectDB today and i'm having problem using command Collections.sort in persisted object.  Attempt to modify an object with no active transaction when NontransactionalWrite ... in DB, just sort it to show at the moment. someone can help me ?   thanks David Bentolila   Hi
Issue
26

Sort of very large objects - out of memory

processing mechanism in sorting very large objects. This requires a fix, but meanwhile, adding a composite ... could even be faster if both sort keys were either ascending or descending, since then a range query could just
Issue
26

Strange Error with Criteria API and Sorting

the sorted results. However, running this with the criteria API produces this error: Caused by: com ... , this is more than a show stopper, we cannot even sort right now!! A test case that demonstrates the problem
Forum
23

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

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

What is new in ObjectDB 2.0?

query execution. Support of composite indexes and using indexes in query result sort. Improved query
Manual
17

CRUD Database Operations with JPA

, can be used to retrieve selected objects from the database (using a WHERE clause), sort the results