What operoation is equal to the sql "in" when I filter the string in grid?

[PEIYANG]

For example ,I want to find the object that its id in "101,1011,1001'  and  name  "Lucy" called filterstring.Need I have to filter 3 times?
  $("#Grid").data("kendoGrid").dataSource.filter([
      { field: "id", operator: "eq", value: "101"},
{ field: "id", operator: "eq", value: "1001"},
{ field: "id", operator: "eq", value: "1001"}
{ field: "name", operator: "eq", value: "Lucy"}
                   ]);

[Atanas Korchev]

Hello,

 The Kendo DataSource doesn't provide an equivalent to the "in" SQL operator. All supported operators are listed here: http://docs.kendoui.com/api/framework/datasource#configuration-filter.operator

 You can use an "or" filter in your case:

dataSource.filter( {
    logic: "or",
    filters: [
       { field: "id", operator: "eq", value: "101"},
       { field: "id", operator: "eq", value: "1001"},
       { field: "id", operator: "eq", value: "1001"},
       { field: "name", operator: "eq", value: "Lucy"}
    ]
});

All the best,
Atanas Korchev
the Telerik team

[PEIYANG]

Thanks,Atanas Korchev,It seems that the Kendo DataSource also not provide an equivalent to the "Like" SQL operator? It is right?

[Atanas Korchev]

Hello,

 All supported filter operators are listed in the documentation. Here is a quote:

The supported operators are: "eq" (equal to), "neq" (not equal to), "lt" (less than), "lte" (less than or equal to), "gt" (greater than), "gte" (greater than or equal to), "startswith", "endswith", "contains". The last three are supported only for string fields.

Regards,
Atanas Korchev
the Telerik team