Correlation between entities in the view baseb on custom column

[adamzrk]

Suppose I have entity with two fields being foreign key to the same entity, but due to business requirements one might be initialized and other not. One is generated by hibernate and is a foreign key.

@Entity
class User {

  @Column
   private Long relatedAdressId;

    @Nullable
    @ManyToOne(fetch = FetchType.LAZY)
    private Adress adress;

}

@Entity
class Adress {
   @Id 
   private Long id;
}

an having entity view:

@EntityView(Userclass)
public interface UserView {

      @MappingCorrelated(
            correlationBasis = "relatedAdressId",
            correlator = MyCorrelationProvider.class,
            fetch = FetchStrategy.JOIN
    )
    AdressView getAdress();

 static class MyCorrelationProvider implements CorrelationProvider {

        @Override
        public void applyCorrelation(CorrelationBuilder builder, String correlationExpression) {
            final String alias = builder.getCorrelationAlias();

            builder.correlate(Adress.class)
                    .on( "adress.id").eqExpression(correlationExpression)
                    .end();
        }
    }
 

But it produces query with invalid join condition.
How to make Blaze to join user and adress with condition:
user.related_adress_id = adress.id
and not:
user.adress_id = adress.id ?

The question is - how using entity correlation I may select the related entity not using foreign key column but the other - helper column?
Seems like @MappingCorrelated always uses foreign key column and it is not possible to override it.

[adamzrk]

Problem solved - I have used JoinOnBuilder and it works as expected.