Kendo Grid filter for Odata

[Amit]

We are using Kendo Grid in Asp.Net MVC application. The grid is configured and mapped to a Odata WebAPI for server filter to a Odata controller. Currently, any filter on two or more than two columns works with AND condition for filter. I want to convert into OR instead of AND. How can I do that ?

[Alex Hajigeorgieva]

Hi, Amit,

You can override the filter logic operator in the dataSource.transport.read.data function:

.DataSource(dataSource => dataSource
   .Custom()
   .Type("odata")
        .Transport(transport =>
           transport.Read(read => read.Action("Read", "Home").Data("additionalData"))
        ) 
)
<script>
    function additionalData(options) {
        if(options.filter){
            options.filter.logic = "or";
        }
    }
</script>

https://dojo.telerik.com/@bubblemaster/uzoCEZEv

                        transport: {
                                read: {
                                  url:"https://demos.telerik.com/kendo-ui/service/Northwind.svc/Orders",
                                  data: function(options){
                                    if(options.filter){
                                      options.filter.logic = "or";
                                    }
                                  }
                                }
                            },

Kind Regards,
Alex Hajigeorgieva
Progress Telerik