DynamicQuery Like with OR Operator

[Jawad Saleem, modifié il y a 9 années.]

I want to add search filters LIKE attribute with OR Operator, Below code automatically add AND criteria with LIKE.

Junction disjunction = RestrictionsFactoryUtil.disjunction();

if(Validator.equals(propertyName, "firstName")) {
Property firstName = PropertyFactoryUtil.forName("firstName");
disjunction .add(firstName.like(keywords));
}

if(Validator.equals(propertyName, "lastName")) {
Property lastName = PropertyFactoryUtil.forName("lastName");
disjunction .add(lastName.like(keywords));
}

if(Validator.equals(propertyName, "email")) {
Property email = PropertyFactoryUtil.forName("email");
disjunction .add(email.like(keywords));
}

customerDynamicQuery.add(disjunction);

[mohammad azaruddin, modifié il y a 9 années.]

try this

Criterion criterion1 = RestrictionsFactoryUtil.like("firstName", keywords);
Criterion criterion2 = RestrictionsFactoryUtil.like("lastName", keywords);
Criterion criterion3 = RestrictionsFactoryUtil.like("email", keywords);
Criterion criterion4 = RestrictionsFactoryUtil.or(criterion1, criterion2);
Criterion criterion5 = RestrictionsFactoryUtil.or(criterion4, criterion3);
customerDynamicQuery.add(criterion5);