[FIXED] How can I add in my audit table a column with actions that was done (modify, create,delete) using Hibernate Envers?

Issue

I know the type of operations are represented like numbers but can I make them appear as string type ("UPDATE / DELETE / INSERT")

I think rev or revtype show what type of operation is ( I tried edit, delete and insert in this order and that s the result )

href="https://i.stack.imgur.com/jVYvn.png" rel="nofollow noreferrer">This is my product_aud

Solution

The change history is stored in the SOME_ENTITY_AUD tables corresponding to the SomeEntity instances. The SOME_ENTITY_AUD table has a field - REVTYPE - Represented by numbers from 0 to 2:

• 0-ADD
• 1-MOD
• 2-DEL

See more details in the same question.

Answered By - Andrew Dark
Answer Checked By - Robin (JavaFixing Admin)