Querying all Hibernate Envers revisions between two dates

Question

I have just started using Hibernate Envers for audit, and i will like to know if there is a way to get all the revisions of a class between two dates. up until now i was using: ``` AuditQuery query = reader.createQuery().forRevisionsOfEntity(MYCLASS.class, false, true); query.add(AuditEntity.revisionNumber().le(reader.getRevisionNumberForDate(MYDATE))); ``` to get the revisions of a particular date, but is there a way to recover all the revisions between for example: MYDATE1 and MYDATE2?

Accepted Answer

You can use `between` method of `AuditProperty` to Apply a "between" constraint.

http://docs.jboss.org/envers/api-new/org/hibernate/envers/query/criteria/AuditProperty.html

Querying all Hibernate Envers revisions between two dates

Solution

Problem