Thanks for the reply but what I need is to build such HQL using criteria, the HQL example works fine. I just want to create it using Criteria interface because I need to use this as a subquery for another Criteria.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Possible to create this HQL equivalent using Hibernate Criteria?