Complex filtering problem

[Karl]

I am creating a fairly simple datasource, with at least two filters but possibly more depending on what the user has set up.  When I have two filters it is fine.  I set the datasource filter up as follows:

{
logic: "and",
filters: [
    { field: date, operator: "gte", value: "01/11/2013" },
    { field: date, operator: "lte", value: "30/11/2013" },
]
}

This works correctly when I fetch the data.  However if I have a 3rd filter I get the error: "Unable to cast object of type 'Kendo.Mvc.CompositeFilterDescriptor' to type 'Kendo.Mvc.FilterDescriptor'."

I have tried a few structures for the filter:
{
logic: "and",
filters: [
    { field: date, operator: "gte", value: "01/11/2013" },
    { field: date, operator: "lte", value: "30/11/2013" },
    { field: userName, operator: "eq", value: "JBLOGGS" }
]
}

{
logic: "and",
filters: [ {
    logic: "and",
    filters: [
    { field: date, operator: "gte", value: "01/11/2013" },
    { field: date, operator: "lte", value: "30/11/2013" }] },
    { field: userName, operator: "eq", value: "JBLOGGS" } ]
    }
]
}

And other variations, but all of them give the same error.

Any help would be appreciated.
Thanks in advance.

[Petur Subev]

Hello Karl,

The second filter object that you shared is not valid JSON:

{
logic: "and",
filters: [ {
    logic: "and",
    filters: [
    { field: date, operator: "gte", value: "01/11/2013" },
    { field: date, operator: "lte", value: "30/11/2013" }] },
    { field: userName, operator: "eq", value: "JBLOGGS" } ]
    }
]
}

Here is what I tried on my side and it is working fine.

$(function () {
    $('#people').data('kendoGrid').dataSource.filter([{
        logic: "and",
        filters: [
            { field: "BirthDate", operator: "lte", value: "11/01/2013" },
            { field: "BirthDate", operator: "lte", value: "11/30/2013" },
            {
                logic:"or",
                filters: [
                    { field: "BirthDate", operator: "eq", value: "06/26/1968" },
                    { field: "BirthDate", operator: "gte", value: "11/11/2013" }
                ]
            }
        ]
    }]
  )
})

Send a small demo project that reproduces the exception that you shared so we can investigate and advise you how to avoid the exception that you have on your side.

Kind Regards,
Petur Subev
Telerik

[Karl]

My apologies, what appeared to be a kendo error was in fact an error elsewhere.  I have resolved this now.  Many thanks for your help.