Hi @ all, I am concerned with a problem regarding criteria and hql. In first step a complex criteria construction limits a big amount of datasets. In second step a hql calculation should be performed on these preselected datasets of step one.
The problem is that the code of both has been developed seperately and i am wondering if it is possible to just perform the hql query as a subquery on the result of the first limitation of data. Both calculations should be performed on database level because it is a big amount of data.
I would be very happy for any help or advice.
Thanks in advance