This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
NewerOlder