Hi,

I'm using the Criteria API as I have dynamic constraints within my object. But also I need to include a "group by" clause which makes reference to nested properties in my object.

I mean, I have:



so as it can be seen I want to indicate an object within an object within another object. But it doesn't work. I get the following error:



Using HQL I imagine it could be:



But I can't use HQL.

Any ideas?

try to create an alias



i didn't try it so im not sure

Hi chrigi,

Thanks for your hint, but it doesn't work. The aliases work for the rest of the Criteria criterion, but not for using them in the projections (at least as far as I know).

Any alternatives?

I finally solved it!

Yes, you were right with using aliases, but my problem was the way I was using them. It seems that you cannot use an alias directly inside the projection, but you have at least to indicate one member of the alias.

For example, imagine you have an alias "sf". You can't do:



but you can do:



So forum admins please give my positive vote to chrigi ;-)