Example from HQL documentation showing a Subselect in SELECT clause:


Can this be done with the Criteria query api?
An example or hint as to where to look in the api would be greatly appreciated. Thanks

I believe that what I need is a Projection. I don't see a built-in one in the Projections factory, but I am guessing that if the API can generate the SQL for subqueries in the WHERE clause it would not be much work to extend in to the SELECT and/or FROM clause.

I am going to give it a shot. Any help or suggestions would be appreciated. Especially if someone has already done this.

Thanks,

check this post, probably give some information.
viewtopic.php?t=955642

I checked out the thread, I scanned through and it seems to discuss subqueries in the where clause, while i am looking for a subquery in the select clause. I read it quickly so might have missed something that might help.