Unfortunately, joins are not supported. You can only specify ids of related entities.
Thanks for your timely information Adam.
I have implemenetd the same in a different way with 2 queries.
I am having some problems joining the entities myself and struggling with a solution and would appreciate any advice.
I have a specific question. Using envers would it not be possible to use AuditQuery on the two different entity types that are related (parent child or one to many) and then insert the result into some sort of temporary or virtual representation of the audited table (not the ENTITY_AUD table but the ENTITY table) and then to do my query on the virtual table using standard hibernate? If this would work, how do I define / use a temp or virtual representation of the audited table?