title: How to fetch all changes of values from _AUD table
body: <p>We are using hibernate-envers 3.6.3.final and the <code>*._AUD</code> tables are created successfully. I need to generate a report (a table) based log information to shows to the user, a list of changes of an object. Something likes the following</p>
  
  <pre><code>Id | modified_by  | old_value | new_value | timestamp
  1  | user1        | Boby77    | Boby      | 2015-02-04 23:18:17
  2  | user2        | Boby      | Bob       | 2015-02-06 20:20:10
  </code></pre>
  
  <p>I am unable to fetch all the data from <code>*._AUD</code> table. How do I fetch all changes of values from the audit table? How do I do this?</p>
  
  <p>I am using the following code but it returns the default revisions:</p>
  
  <pre><code>AuditQuery auditQuery = AuditReaderFactory
                  .get(sessionFactory.getCurrentSession()).createQuery()
                  .forRevisionsOfEntity(Myentity.class, false, true);
  
  List&lt;Object[]&gt; list = auditQuery.getResultList();
  </code></pre>
  
  <p>The above query returns the following:</p>
  
  <blockquote>
    <p>XXXXXXXXXXXXXX :: bla.bla.Myclass@71587682<br/>
        XXXXXXXXXXXXXX :: DefaultRevisionEntity(id = 1, revisionDate = 12 May, 2015 4:25:16 AM)<br/>
        XXXXXXXXXXXXXX :: MOD<br/>
        XXXXXXXXXXXXXX :: bla.bla.Myclass@66cc8af0<br/>
        XXXXXXXXXXXXXX :: DefaultRevisionEntity(id = 2, revisionDate = 12 May, 2015 4:31:02 AM)<br/>
        XXXXXXXXXXXXXX :: DEL<br/>
        XXXXXXXXXXXXXX :: bla.bla.Myclass@7eb5c749<br/>
        XXXXXXXXXXXXXX :: DefaultRevisionEntity(id = 3, revisionDate = 12 May, 2015 4:31:02 AM)<br/>
        XXXXXXXXXXXXXX :: ADD<br/>
        XXXXXXXXXXXXXX :: bla.bla.Myclass@502eca9c<br/>
        XXXXXXXXXXXXXX :: DefaultRevisionEntity(id = 4, revisionDate = 12 May, 2015 5:08:52 AM)<br/>
        XXXXXXXXXXXXXX :: MOD<br/></p>
  </blockquote>
  
  <p>But I don't want this. I need the all changes of what I did liks the above table. How do I do this?</p>