Using a kendoGrid with an xml datasource and serverAggregates, defining "aggregate" throws an error "Object [object Object] has no method 'aggregates'"
I am including a code example below. It works if you remove the "aggregate: [{field: "qty", aggregate: "sum"}],".
Here is the itemReport.xml datasource:
<xml version="1.0" encoding="UTF-8">
<page>
<items>
<item itemName="testitem" qty="2" />
<item itemName="Garlic Rolls 1(dozen)" qty="1" />
<item itemName="Triple Dipper" qty="1" />
<item itemName="Classic Bacon Burger" qty="1" />
<item itemName="Classic Chicken" qty="5" />
</items>
<aggregates>
<qty>
<sum>18</sum>
</qty>
</aggregates>
<total val="7"/>
</page>
And the page source:
<!DOCTYPE html>
<html>
<head>
<link href="http://cdn.kendostatic.com/2013.3.1119/styles/kendo.common.min.css" rel="stylesheet" />
<link href="http://cdn.kendostatic.com/2013.3.1119/styles/kendo.default.min.css" rel="stylesheet" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://cdn.kendostatic.com/2013.3.1119/js/kendo.all.min.js"></script>
</head>
<body>
<div id="example" class="k-content">
<div id="grid"></div>
</div>
<script>
$(document).ready(function() {
var grid = $("#grid").kendoGrid({
dataSource: {
transport: {
read: "itemReport.xml",
cache: false
},
schema: {
type: "xml",
data: "/page/items/item",
aggregates: "/page/aggregates",
model: {
fields: {
itemName: "@itemName",
qty: "@qty"
},
},
total: "/page/total/@val",
},
serverAggregates: true,
aggregate: [{field: "qty", aggregate: "sum"}],
pageSize: 5,
serverPaging: true,
serverSorting: true,
serverFiltering: true
},
height: 450,
sortable: true,
pageable: true,
reorderable: true,
resizable: true,
columns: [
{
field: "itemName",
title: "Item"
},
{
field: "qty",
title: "Sold"
}
]
});
});
</script>
</body>
</html>
I am including a code example below. It works if you remove the "aggregate: [{field: "qty", aggregate: "sum"}],".
Here is the itemReport.xml datasource:
<xml version="1.0" encoding="UTF-8">
<page>
<items>
<item itemName="testitem" qty="2" />
<item itemName="Garlic Rolls 1(dozen)" qty="1" />
<item itemName="Triple Dipper" qty="1" />
<item itemName="Classic Bacon Burger" qty="1" />
<item itemName="Classic Chicken" qty="5" />
</items>
<aggregates>
<qty>
<sum>18</sum>
</qty>
</aggregates>
<total val="7"/>
</page>
And the page source:
<!DOCTYPE html>
<html>
<head>
<link href="http://cdn.kendostatic.com/2013.3.1119/styles/kendo.common.min.css" rel="stylesheet" />
<link href="http://cdn.kendostatic.com/2013.3.1119/styles/kendo.default.min.css" rel="stylesheet" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://cdn.kendostatic.com/2013.3.1119/js/kendo.all.min.js"></script>
</head>
<body>
<div id="example" class="k-content">
<div id="grid"></div>
</div>
<script>
$(document).ready(function() {
var grid = $("#grid").kendoGrid({
dataSource: {
transport: {
read: "itemReport.xml",
cache: false
},
schema: {
type: "xml",
data: "/page/items/item",
aggregates: "/page/aggregates",
model: {
fields: {
itemName: "@itemName",
qty: "@qty"
},
},
total: "/page/total/@val",
},
serverAggregates: true,
aggregate: [{field: "qty", aggregate: "sum"}],
pageSize: 5,
serverPaging: true,
serverSorting: true,
serverFiltering: true
},
height: 450,
sortable: true,
pageable: true,
reorderable: true,
resizable: true,
columns: [
{
field: "itemName",
title: "Item"
},
{
field: "qty",
title: "Sold"
}
]
});
});
</script>
</body>
</html>
2 Answers, 1 is accepted
0
Ryan
Top achievements
Rank 1
Rank 1
answered on 02 Jan 2014, 05:29 PM
Can someone try this test case and let me know if its a bug or something I am doing wrong?
Because this issue means I cannot add footers to the grid like:
footerTemplate: "Sum: #= sum # "
Because this issue means I cannot add footers to the grid like:
footerTemplate: "Sum: #= sum # "
0
Hello,
Using server aggregates with an XML dataSource is not currently supported. It will require to specify how the aggregates can be retrieved from the XML which is not currently possible. If this is needed in your scenario then I can suggest to use a normal dataSource and parse the response to JSON in the schema parse function e.g.
Regards,
Daniel
Telerik
Using server aggregates with an XML dataSource is not currently supported. It will require to specify how the aggregates can be retrieved from the XML which is not currently possible. If this is needed in your scenario then I can suggest to use a normal dataSource and parse the response to JSON in the schema parse function e.g.
schema: { data: "data", total: "total", aggregates: "aggregates", parse: function (response) { var doc = $(response), items = doc.find("items").children(), total = doc.find("total").attr("val"), aggregates = doc.find("aggregates").children(), result = {data: [], aggregates: {}, total: total}; items.each(function () { var item = $(this); result.data.push({ itemName: item.attr("itemName"), qty: item.attr("qty") }); }); aggregates.each(function () { var item = $(this), agg = {}; item.children().each(function () { agg[$(this).prop("tagName")] = parseFloat($(this).text()); }); result.aggregates[item.prop("tagName")] = agg; }); return result; }, model: { fields: { itemName: {type: "string"}, qty: {type: "number"} } } }Regards,
Daniel
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!