Hibernate HQL - retrieve with most recent date field?

[davout]

I want to retrieve a record from an invoice table that includes the most recent invoice date.

In SQL this would be something like...

select * from Invoice where InvoiceDate = (select Max(InvoiceDate) from Invoice)


How would this be constructed in HQL?

[karldmoore]

It's always a good idea to have a read of the reference manual.
http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#queryhql-aggregation

[Andrei Stefan]

And also this section: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#queryhql-subqueries

[cobra82]

you can use Hibernate Criteria like

Criteria criteria = getSession().createCriteria(Invoice.class).setProj ection(Projections.max("InvoiceDate"));

[karldmoore]

Or if you really, really want to. You can even do it in native SQL through Hibernate. I think that's most of the options.
http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#querysql

[objec]

you can use Hibernate Criteria like

Criteria criteria = getSession().createCriteria(Invoice.class).setProj ection(Projections.max("InvoiceDate"));

Actually this Criteria query will only generate the subquery portion: select Max(InvoiceDate) from Invoice

To get the full query you could use this:

DetachedCriteria maxQuery = DetachedCriteria.forClass( Invoice.class );
maxQuery.setProjection( Projections.max( "InvoiceDate" ) );

Criteria query = getSession().createCriteria( Invoice.class );
query.add( Property.forName( "InvoiceDate" ).eq( maxQuery ) );