As I pointed out in HHH-3562 Open , the @Where and @WhereJoinTable annotations are tricky because they supply raw SQL fragments which cannot easily be appended to a HQL/JPQL generated query.

I'm inclined to suggest we might want to introduce Envers-specific annotations which are meant to supply HQL/JPQL fragments instead to allow Envers users to influence collections and join-tables with the appropriate predicates; e.g. @AuditWhere and @AuditWhereJoinTable.

Thoughts?