Hi there

I would like to find a calculated field inside my DetachedCriteria query and return it as part of the result.

For example: I have an end date and a start date and I want to calculate the duration between the two (the exact field is not in the database object)

I have not been able to do this - any ideas if it's possible? Projection somehow ?

And if this is possible - is it possible to do an orderBy on the calculated field?


Thanks++

"I have an end date and a start date and I want to calculate the duration between the two"

What are u going to do with this?

I'd like to get the result of the duration in the result set, as well as run an order by on it.

Try sql projection. Something like

criteria.setProjection(Projections.sqlProjection("(enddate - startdate) as duration", new String[]{"duration"}, new org.hibernate.type.DateType[]{new org.hibernate.type.DateType()}),"duration");

and then

criteria.addOrder((Order.asc("duration")).ignoreCase());

Please check if DateType is the correct type of the value returned by sql fragment.