I was trying to figure out how to retrieve the most recent version of everything of a particular type which has changed since a particular revision. So far I've been unsuccessful, so I was wondering if someone might be able to give me some pointers. Here's what I've tried so far...
This query fetches everything that has changed since the specified revision:
AuditQuery query = auditReader.createQuery()
.forRevisionsOfEntity(entityClass, false, true)
.add(AuditEntity.revisionNumber().gt(revision))
If I add a maximize restriction on the revision number, I get a single item which changed at the highest revision number, which isn't what I'm looking for.
I could do this in SQL or HQL by grouping by ID and then selecting the maximum revision from each group, but I didn't see a way to pass an HQL query to the audit reader.
And, of course, I can use the above query and then filter out the older items from the result in Java, which is what I'm doing now.
Anyway, I was wondering if it was possible to accomplish this by restricting the query in some way.
Thanks.