ComplexHorizontalQuery.java

AuditQuery q = auditReader.createQuery().forEntitiesAtRevision(Book.class, 2);
q.traverseRelation(“publisher”, JoinType.LEFT, “p”);
q.add(AuditEntity.and(
AuditEntity.or(AuditEntity.property(“title”).ilike(“JPA”, MatchMode.ANYWHERE), AuditEntity.property(“title”).ilike(“Hibernate”, MatchMode.ANYWHERE)),
AuditEntity.property(“p”, “name”).ilike(“Manning”)));
q.addOrder(AuditEntity.property(“title”).asc());
List<Book> audit = q.getResultList();

GetAllRevisionsOfEntity.java

AuditQuery q = auditReader.createQuery().forRevisionsOfEntity(Book.class, true, true);
q.add(AuditEntity.id().eq(b.getId()));
List<Book> audit = q.getResultList();

GetFirstRevisionWithGivenTitle.java

AuditQuery q = auditReader.createQuery().forRevisionsOfEntity(Book.class, false, true);
q.addProjection(AuditEntity.revisionNumber().min());
q.add(AuditEntity.id().eq(b.getId()));
q.add(AuditEntity.property(“title”).eq(“Hibernate Tips – 64 Tips for your day to day work”));
Number revision = (Number) q.getSingleResult();

SimpleHorizontalQuery.java

AuditQuery q = auditReader.createQuery().forEntitiesAtRevision(Book.class, 2);
q.add(AuditEntity.property(“title”).ilike(“Hibernate”, MatchMode.ANYWHERE));
q.addOrder(AuditEntity.property(“title”).asc());
List<Book> audit = q.getResultList();