Getting all deleted entities of a given class

[bestage]

I need to implement the following use case in a project using enver:

- return all entities of the given class MyClass which were deleted during a month, e.g. between 01.01.2010 and 31.01.2010.

I have tried different queries, by adding restriction to the RevisionType = DEL... But it returns only empty entites, as this is the default behaviour.

Now I saw a setting I can use to force envers to store full entity on delete.

But is there any other way to solve this? Because it is not really nice to store entites redundantly in my history table....

[adamw]

What do you exactly mean by "getting deleted entities"? Using the query you can get the ids of the entities and the revisions when they were deleted, then you can retrieve them at the proper revisions (e.g. the last-but-one).

Adam