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"}]
});
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"}]
});