Hi there

I have query which I need to execute in a nested "and, or" form e.g. select * from students where student.isactive=true and(student.name like '%XYz%' or student.fathername like '%XYz%') and student.age > 13

Kindly tell me how to implement this in self service with predicate expression.

PredicateExpressions have AddWithOr() and AddWithAnd() which can accept predicates, and also can accept another PredicateExpression (nested).

Can you please elaborate it?

Here is a simple example:

var filter = new PredicateExpression(CustomerFields.Country == "UK");

var subFilter = new PredicateExpression(CustomerFileds.Country == "US");
subFilter.AddWithAnd(CustomerFileds.Type == "VIP");

filter.AddWithOr(subFilter);

The above would produce:

WHERE
Country = 'UK'
OR 
(Country = 'US' AND Type = 'VIP')