I have separated the auditing support and revisions in my solution. It works fine, but I have no idea how to create a query to get all revisions where the timestamp and the modifiedBy from REVINFO is mapped into the List<MyEntity> query results. Like joining the MYENTITY_AUD and the REVINFO on REV for lastModified columns. For created columns it is even more complicated, because it might requires a subquery with REVTYPE = 0.

private List<MyEntity> allRevisions() {
  AuditReaderFactory.get(entityManager).createQuery()
    .forRevisionsOfEntity(MyEntity.class, true, true)        
    .addOrder(AuditEntity.revisionNumber().asc())
    .getResultList();
}

My tables looks like this:

MYENTITY table
+--------------------------------------------------------------------------+
| ID | MYDATA | CREATEDBY | CREATEDDATE | LASTMODIFIEDBY | LASTMODIFIEDDATE |
+--------------------------------------------------------------------------+

MYENTITY_AUD table
+----------------------------+
| ID | REV | REVTYPE | MYDATA |
+----------------------------+

REVINFO table
+----------------------------+
| REV | REVTSTMP | MODIFIEDBY |
+----------------------------+

Examples from the code:

@Audited
@Entity
public class MyEntity implements Auditable {
    
    private String myData;

    @CreatedBy
    @NotAudited
    private String createBy;

    @CreateDate
    @NotAudited
    private LocalDateTime createdDate;

    @LastModifiedBy
    @NotAudited
    private String lastModifiedBy;

    @LastModifiedDate
    @NotAudited
    private LocalDateTime lastModifiedDate;
}

@Entity
@Table(name = "REVINFO")
@RevisionEntity(MyRevisionListener.class)
public class MyRevisionEntity implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @RevisionNumber
    @Column(name = "REV")
    private int id;

    @RevisionTimestamp
    @Column(name = "REVTSTMP")
    private long timestamp;

    @Column(name = "MODIFIED_BY")
    private String modifiedBy;
    ...
}

public class MyRevisionListener implements RevisionListener {

    @Override
    public void newRevision(Object revisionEntity) {
        MyRevisionEntity revision = (MyRevisionEntity) revisionEntity;
        revision.setModifiedBy(MyContext.getUserName())
    }
}

Thanks.