Hi,

I have this requirement wherein I need to fetch the record with the maximum Timestamp from a table.

How do I do this in Hibernate?

Thanks
Any help would be appreciated.

It may be something like this:

Criteria shipWindowCriteria = session.createCriteria(Employee.class)
.add(Expression.eq("EmpNumber",poNbr)
.add(Expression.eq("CustCd",custCd)

I need to add some Expression "TimeStamp" which would be the max of all the Timestamps available for that table.

Something of the sort of :

.add (Expression.eq("TimeStamp", MAX( of all the Timestamps));

Please help.

Thanks

I'll try to help, although I'm not exactly clear what the intent is. I'm not sure if you want the Employee with the greatest Timestamp or the greatest Timestamp itself.

If you want the Employee record with the greatest timestamp then you can order the result set by timestamp in descending order and get the first record:



Another option would be to have a sql subquery, although this would not be as portable.

Another option would be to use a projection to get the max, but since I don't have too much experience with this I won't comment further.

Hope this helps!

Hi aphawkes,

Thanks for your suggestion.

However, it's giving,
The method addOrder(Order) is undefined for the type SimpleExpression

Hi aphawkes,

Thanks a Lot!

It works.

Regards.