Hi, according to our history display requirements, we must always additionally provide the previous revision, so we always execute two requests:
Number previousRevision = (Number) reader.createQuery()
.forRevisionsOfEntity(DictionaryRecordEntity.class, false, true)
.addProjection(AuditEntity.revisionNumber().max())
.add(AuditEntity.id().eq(id))
.add(AuditEntity.revisionNumber().lt(currentRevisionNumber))
.getSingleResult();
reader.find(DictionaryRecordEntity.class, id, previousRevision);
We use ValidityAuditStrategy (REVEND field is present) and want to use a single query based on REVEND to find previous revision like:
reader.createQuery()
.forRevisionsOfEntity(DictionaryRecordEntity.class, false, false)
.add(AuditEntity.id().eq(id)) .add(AuditEntity.revisionNumberEnd().eq(123))
.setMaxResults(1)
.getSingleResult();
Best regards.