I need to find value duplicate count in the database use an HQL query instead of reading in an iterating over lots of objects.
The query should only count records whose field values match.
It should compare all but a specified list of fields. This will allow the developer to tell it to ignore things like the id, version and relationship fields.
Importantly this will not include embedded element collections. Is the following a correct approach?



Where vf1, vf2 and ec1 have been taken from the object to get the value duplicate count of.

As an aside is there anyway of specifying which fields to ignore instead of which to include.