Hi!

Is it possible to join two classes that hasn't got a bidirectional mapping?

Here's the scenario. I have an Item class that has a mapping to a SubCategory. Every entity has a Translation class but the translation class is only aware of the entity and not visa versa.

ItemTranslation has an Item
Item is not aware of ItemTranslation
SubCategoryTranslation has an SubCategory
SubCategory is unaware of the SubCategoryTranslation
Item has a Subcategory

In my criteria I start from ItemTranslation and add alias for the item
and the subcategory. createAlias( Item , itemTranslation.Item )
createAlias( subcategory , item.Subcategory ). Is it possible to reference SubCategoryTranslation here?

You can achieve something like that with a detached criteria and a subquery (as long as you only want to filter on SubCategoryTranslation and not fetch them).



and then add this detached criteria as a subquery to your first criteria:

Thanks!

I would have liked to set a Transformers.AliasToBean for this. I will try!