Hello

Thanks a lot for envers

For one of our use cases, we needed an administrative audit search screen, with filters like entities, from, to, entity id and so forth.

Then the results are put in the following order: entity id, some context data, id and then the entity content.

For example: entity user, context data, id = 1234,

. It this example manager is another instance of user.

As such, it would have been perfect for us to "just" get the data contained in each audit table.

However we didn't find a simple way to achieve it through the AuditQuery API: when then had Hibernate entities, with the need to just get the id from the linked Entities. Furthermore Jackson then had troubles with bi directionnals relationships.

In the end we went through direct SQL access to the audit tables. It's a bit of a pity but was quickly done and returns exactly what we need.

However, it would be nice to have an API for such needs don't you think?

Thanks in advance

Cheers,
Joseph