Hibernate Community • View topic - HQL specify an order by property order?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL specify an order by property order?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

crossfire

Post subject: HQL specify an order by property order?

Posted: Tue May 18, 2010 5:32 am

Newbie

Joined: Tue May 18, 2010 5:30 am
Posts: 1

How can I order by a specific property order in HQL?

For MySQL I can use:

Code:

SELECT * FROM question q ORDER BY q.status IN ("DONE", "NO_ACTION"), q.status IN ("NEW","SAVED"), q.created DESC

but HQL doesn't allow

Code:

order by

.

Am I missing something? Is there some other way around this problem?

Thanks

Top

ivirani

Post subject: Re: HQL specify an order by property order?

Posted: Wed May 19, 2010 12:02 pm

Regular

Joined: Tue May 11, 2010 5:50 pm
Posts: 54
Location: Norman, Ok, U.S.A

You can look into the Criteria API. Very easy to use.
Criteria criteria = session.createCriteria(class)
criteria.add(Restrictions.in(restirctions...)
criteria.orderBy(orderby field) (or some thing like this)

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum