Hibernate version:3.2.RC2

I have ordered all my activities on description .

Every activity has a percentcompleted intvalue from 0 to 100.
I want to order by 100% completed then by 0 to 99.

So that all activities that are finished will display at the bottom of the list.

How would I create a query that accomplishes this?

This is my simplified query that I'm basing the sort on:


Thanks in advance for any help

I'm not sure how to do it in Hibernate using the Criterion API, but you can use a "CASE" expression in SQL to achieve this effect. The syntax for it differs between databases, here's how Postgres does it:

http://www.postgresql.org/docs/7.4/stat ... l#AEN11384

According to the Hibernate manual, Hibernate supports the "CASE" construct in HQL:

http://www.hibernate.org/hib_docs/v3/re ... xpressions

But I've never used it myself, so I don't know how well it works.

Can you try to give an example?

if I use Case in the where clause i get another variable.

and i only want to get the activity objects, and order them by the case..

This is what i want it to do in pseudo code

order by percentCompleted asc where percentCompleted == 100

returns a list: