在子查询中使用父查询entitypath来querydsl

Question

select a1.agreement_id, ad1.agreement_detail_id
from agreement a1
  inner join agreement_details ad1 on a1.agreement_id=ad1.agreement_id 
where ad1.transaction_id in (
  select max(ad2.transaction_id) 
  from agreement_details ad2 
    inner join agreement a2 on ad2.agreement_id=a2.agreement_id 
  where 
    ad2.transaction_id<=1234
    and a2.agreement_id=a1.agreement_id 
    and a2.entity_split_id=5678 
) 
order by a1.agreement_id asc

QAgreement a1 = QAgreement.agreement;
QAgreementDetails ad1 = QAgreementDetails.agreementDetails;
QAgreement a2 = QAgreement.agreement;
QAgreementDetails ad2 = QAgreementDetails.agreementDetails;
HibernateQuery query = getHibernateQuery();
query.from(a1)
    .innerJoin(a1.agreementDetailsesByAgreementId, ad1)
    .fetch()
    .where(ad1.transactionId.in(
      new JPASubQuery().from(ad2)
        .innerJoin(ad2.agreementByAgreementId, a2)
        .where(ad2.transactionId.loe(maxTransactionId))
        .where(a1.agreementId.eq(a2.agreementId))
        .where(a2.entitySplitByEntitySplitId.entitySplitId.eq(entitySplitId))
        .list(ad2.transactionId.max())))
        .orderBy(a1.agreementId.asc());

select  -- Some columns removed for brevity
   agreement0_.agreement_id as agreemen1_0_0_,
   agreementd1_.agreement_detail_id as agreemen1_11_1_ 
from
   agreement agreement0_ 
inner join
   agreement_details agreementd1_ 
       on agreement0_.agreement_id=agreementd1_.agreement_id 
where
   agreementd1_.transaction_id in (
       select
           max(agreementd2_.transaction_id) 
       from
           agreement_details agreementd2_ 
       inner join
           agreement agreement3_ 
               on agreementd2_.agreement_id=agreement3_.agreement_id 
       where
           agreementd2_.transaction_id<=1234
           and agreement3_.agreement_id=agreement3_.agreement_id 
           and agreement3_.entity_split_id=5678 
   ) 
order by
   agreement0_.agreement_id asc

您可以看到，子查询中没有使用协议实体路径a1的别名，而是被协议实体路径A2的别名所取代。在querydsl中还需要做一些其他的事情才能生成这个查询吗？

Answer 1

问题是您没有使用唯一变量

QAgreement a1 = QAgreement.agreement;
QAgreementDetails ad1 = QAgreementDetails.agreementDetails;
QAgreement a2 = QAgreement.agreement;
QAgreementDetails ad2 = QAgreementDetails.agreementDetails;

在这种情况下，a1和a2以及ad1和ad2指的是同一路径。

Java代码中的变量名并不重要，您需要使用它们，例如如下所示

QAgreement a1 = new QAgreement("a1");
QAgreementDetails ad1 = new QAgreementDetails("ad1");
QAgreement a2 = new QAgreement("a2");
QAgreementDetails ad2 = new QAgreementDetails("ad2");