Getting Distinct Count of a Projection

gwiley · **Joined:** Tue Apr 10, 2007 10:40 am **Posts:** 8

I'd like to get the distinct row count of a Projection. Can this be done or is there a better way to accomplish the same thing?

Code:

Projection p = Projections.projectionList().add( Projections.property( "_prop1" ), "prop1" ).add( Projections.property( "_prop2" ), "prop2" );
// Now I want to get a distinct count of p - I don't see a way in Projections to accomplish this!

We're using the Criteria API in Hibernate 3.2.1

parasjain01 · **Posted:** Wed Jun 20, 2007 5:13 pm

Try using countDistinct method of class Projections.
Somehow you have to use CountProject class.

gwiley · **Joined:** Tue Apr 10, 2007 10:40 am **Posts:** 8

Thanks for pointer, but CountProjection accepts a property, not a Projection. We're looking to get the count of a Projection. I'm worried this isn't possible because it's a "Bad Idea", but I can't imagine why. So I need help making the choice one way or the other - if it can be done, how? If not, why not?
Thanks for your time!