Problem met when upgrade from querydsl 3 to 4

[Dom]

Hello gentlemen,

I meet a problem when upgrade querydsl from v3 to v4:

in v3:

from(qDeliveryTrace)
   .where(qDeliveryTrace.modifiedDate.between(startDate, endDate)
      .and(qDeliveryTrace.orderResultCode.in(orderCodes)))
   .exists()

it returns Boolean

I wonder how should it be expressed in v4, could anyone help?

Thanks a lot for your attention!

[Richard Richter]

Hi

Is this the JPA support or SQL or what? Also what did you use this construct for?

Virgo

[Dom]

For now, I can come up with 1 solution:

!from(qDeliveryTrace)
   .where(qDeliveryTrace.modifiedDate.between(startDate, endDate)
      .and(qDeliveryTrace.orderResultCode.in(orderCodes))
      .and(qDeliveryTrace.subscriptionId.in(subscriptionIds)))
   .fetchResults().isEmpty()

[Nelson]

What about:

from(qDeliveryTrace)
   .where(qDeliveryTrace.modifiedDate.between(startDate, endDate)
   .and(qDeliveryTrace.orderResultCode.in(orderCodes)))
   .select(Expressions.ONE).fetchFirst() != null