[FIXED] Envers - Showing audit data with relationships

Issue

• I added @Audited in my entities;
• I created my listener to add the user ID to revinfo;

• I can filter audited data with user id, entity class, min and max date, using:

  public <T extends BaseModel> List<Object[]> buscar(Class<T> clazz, Usuario usuario, java.util.Date inicio, java.util.Date fim){
  GregorianCalendar novo = new GregorianCalendar();
  novo.setTime(fim);
  novo.add(Calendar.DAY_OF_MONTH, 1);
  
  AuditReader reader = AuditReaderFactory.get(getEm());
  return reader.createQuery()
      .forRevisionsOfEntity(clazz, false, true)
      .add(AuditEntity.revisionProperty("usuario")
          .eq(usuario))
      .add(AuditEntity.revisionProperty("revtstmp")
          .between(inicio.getTime(), novo.getTime().getTime()))
      .addOrder(AuditEntity.property("id")
          .asc())
      .getResultList();
  
  }
  

But all relationships are lazy, including the @ManyToOne.

I found many post about problems with @OneToMany, but this is not the case

What can I do to access these properties?

PS: I tried, but could not highlight the code.

Solution

All relations in the objects returned by Envers are lazy, regardless if it's a one-to-many or many-to-one.

In an object, to access the related object's properties just call the getter :)

In a query, it's not possible. Joins are not supported, also regardless of the relation type. You can only constraint the id of the related entity, but not its properties.

Answered By - adamw
Answer Checked By - David Marino (JavaFixing Volunteer)