This is a migrated thread and some comments may be shown as answers.

Filter an expanded table

0 Answers 85 Views
Data Source
This is a migrated thread and some comments may be shown as answers.
Alan
Top achievements
Rank 1
Alan asked on 29 May 2012, 04:39 PM
Hi

I have creatred an oData feed that has two tables, Product and ProductAttributes. Given that ProductAttributes is a child table of Products how would I filter the oData via this table. Can this be achieved as follows: (proposed filter in [bold])

    var products = new kendo.data.DataSource({
        type: "odata",
        transport: {
            read: {
                url: "http://odata.com/DataService.svc/Products",
                data: {
                    expand: "ProductAttributes",
                    filter: [{ field: "AttributeType", operator: "contains", value: "Range"},
                               {...},
                               {...}]

                }
            },
        },
        pageSize: 30,
        serverFiltering: true,
        serverPaging: true,
        serverGrouping: true,
        serverSorting: true,
        aggregate: [{ field: "Price", aggregate: "max" }, { field: "Price", aggregate: "min"}]
});

No answers yet. Maybe you can help?

Tags
Data Source
Asked by
Alan
Top achievements
Rank 1
Share this question
or