Eclipse Community Forums: EclipseLink » JPA: order by length?

Home

Home » Eclipse Projects » EclipseLink » JPA: order by length?

JPA: order by length? [message #385414]

Fri, 30 January 2009 06:05

Eclipse User

Is there a way (aside from native queries) to do an order-by-length query?

.... order by length(t.iDescription)

Tom

Re: JPA: order by length? [message #385423 is a reply to message #385414]

Mon, 02 February 2009 08:39

Eclipse User

I don't think JPQL allows this, but you can do it through EclipseLink's
query API.

ExpressionBuilder builder = new ExpressionBuilder();
ReadAllQuery query = new ReadAllQuery(YourClass.class, builder);
query.setSelectionCriteria(builder.get("iDescription").like( "%something%"));
query.addOrdering(builder.get("iDescription").length());

Query jpaQuery =
((JpaEntityManager)entityManager.getDelegate()).createQuery( query);

Please vote for this bug to get these functions added to JPQL in
EclipseLink:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=219814

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

Re: JPA: order by length? [message #385424 is a reply to message #385423]

Mon, 02 February 2009 10:21

Eclipse User

> Query jpaQuery =
> ((JpaEntityManager)entityManager.getDelegate()).createQuery( query);

Do I need a specific version of EclipseLink? The one I use (1.0.2) does not have a createQuery method that accepts a ReadAllQuery as a parameter.

Tom

Re: JPA: order by length? [message #385425 is a reply to message #385424]

Mon, 02 February 2009 10:31

Eclipse User

I used a Collections.sort on the result to order by length. That'll do fine.

Re: JPA: order by length? [message #385430 is a reply to message #385424]

Tue, 03 February 2009 07:54

Eclipse User

Might only be in 1.1, in 1.0 you can use,

Query jpaQuery = entityManager.createQuery("Select a from MyClass a");
((JpaQuery)query).setDatabaseQuery(query);

Previous Topic:	Replacing collections
Next Topic:	not so lazy / locking a record

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 18 11:58:48 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter