Skip to content

Instantly share code, notes, and snippets.

View cavarzan's full-sized avatar

Deividi cavarzan

  • giro.tech
  • Brazil
View GitHub Profile
LOG: Hibernate: select count(customer0_.uid) as col_0_0_ from customer customer0_ left outer join person person1_ on customer0_.person_uid=person1_.uid left outer join company company2_ on customer0_.company_uid=company2_.uid cross join person person3_ cross join company company4_ where customer0_.person_uid=person3_.uid and customer0_.company_uid=company4_.uid and (lower(person3_.name) like ? escape '!' or lower(company4_.name) like ? escape '!') limit ?
Java code:
BooleanBuilder builder = new BooleanBuilder();
builder.or(customer.person.name.containsIgnoreCase(query));
builder.or(customer.company.name.containsIgnoreCase(query));
JPQLQuery jpqlQuery = querydsl.createQuery(customer)
.leftJoin(customer.person, person)
.leftJoin(customer.company, company)