multiple filter conditions

[Jan]

I can do something like

// returns data where orderId is equal to 10248 or customerName starts with Paul

filter: {
    logic: "or",
    filters: [
      { field: "orderId", operator: "eq", value: 10248 },
      { field: "customerName", operator: "startswith", value: "Paul" }
    ]
}

However, I am wondering... if it is possible to get filtering on condition like:
orderID is equal to 10248 or
( customerName starts with "Paul" and customerLastName start with "B" ) ?

Would you help me translate the conditions to filter: { ... } syntax?

Thank you,

[Rosen]

Hello Jan,

You can have multiple nested filter descriptors, for example: 

dataSource.filter({
    logic: "or",
    filters: [
      { field: "fieldA", operator: "eq", value: 100 },
      {
         logic: "and",
         filters: [
             { field: "fieldA", operator: "lt", value: 100 },
             { field: "fieldB", operator: "eq", value: true }
         ]
     }
    ]
});

Regards,
Rosen
the Telerik team

[Diga]

For nested filter, does the implicit logic "and" apply? Or we need to specify it explicitly?

[Rosen]

Hello Diga,

The logic operator is determined by the parent composite descriptor. It should be set explicitly.

Regards,
Rosen
Telerik

 

 

[William]

How do I add a logic operator "OR" for multi-select filters?

 

 

KendoFilters ofilters = new KendoFilters();
            ofilters.filters = new List<KendoFilter>();
            ofilters.logic("Or");
            if (candidate.CompanyName.HasValue())
            {
                ofilters.filters.Add(new KendoFilter() { field = "CompanyName", value = candidate.CompanyName, Operator = "contains" });
               
            }
            if (candidate.CompanyEmail.HasValue())
            {
                ofilters.filters.Add(new KendoFilter() { field = "CompanyEmail", value = candidate.CompanyEmail, Operator = "contains" });
            }

[Plamen]

Hi,

You can refer to our documentation site here where the logic property is described - please have in mind that it should be written in  lower letters. 

Regards,
Plamen
Progress Telerik