Best way to create an audit history table for a specific entity with one revision per row?

[sunfire]

I am looking for a way to display an audit history table for a specific entity incl. a way to highlight the modified fields for each version. Retrieving all versions for a specific entiey already works and I can render a dataTable from it like this:

final List<Node> nodeList = new ArrayList<Node>();
final List<Number> versions = getAuditReader().getRevisions(Node.class, selectedNode.getId());
for (final Number number : versions) {
     final Node node = auditReader.find(Node.class, selectedNode.getId(), number);
     nodeList.add(node);
}

So this works fine and I can easily use this in an audit history table where each row is a revision of the entity.

Now I set org.hibernate.envers.global_with_modified_flag to true in order to track in the revision table what properties changed from version x to y. My question is now is there a built-in way to query a list of maybe property names that have been modified from version x to y for entity z  with ID n.

The intention is to use this information in a dataTable and hightlight the modified fields in each row of the audit history so that the user can quickly identify modified properties.

Thanks

[adamw]

Hmm, if you have the flags, don't you have all the info needed when you read the audited data?

Adam

[sunfire]

What do you mean?

Lets use an explicit example: lets assume the the Node.class has a properties "name",  "size" and primary key "id". Now I want to know what properties were updated between revision 3 and 4 of the Node entity with primary key 123.

Now I am aware of multiple methods of how I could get this information BUT they would either require direct queries to the _AUD tables or fetching both revisions of the entities via Envers and then do equals() comparision for all properties that I am interested in.

But if there is any Envers build-in entity agnosic method of getting this info I'd rather use that then the ways outlined above? Something like

final List<String> modifiedPropertyNameList = getAuditReader().getModifiedProperties(Node.class, 123, 3, 4);

where modifiedPropertyNameList would then maybe contain "name" if only the "name" property of entity 123 was modified from version 3 to 4.

Thanks

[adamw]

Ah, I understand now.

No such built-in method in Envers (yet ).

Currently you can only get the diff from the previous version, and you'd like to flatten multiple such diffs. Possible, but not implemented yet.

Adam

[sunfire]

Ok thanks for the info. So I'll just implement this myself for now. Would be nice (and usefull I think) to get this built-in tho.

Thorsten

[adamw]

<hint>open source project</hint>

Adam

[sunfire]

I know and I would love to contribute but there is so little spare time besides the dayjob and family. And unfortunetly contributing the solution I write for us now is not an option either due to it not being generic enough for others to use and also legal limitations. Sorry

[adamw]

Sure, I understand, I'm often in the same situation

No worries.

Adam