剑道网格-分组和逻辑

Question

我有一个关于Kendo网格和分组的问题--我想在分组网格时加入一些逻辑。我需要按州分组地址，如果州为空，则按国家分组。这可行吗？谢谢。

Answer 1

您可以创建一个隐藏列，其中state is available否则country，然后将数据源设置为按该列分组：

var jsondata = [  
  {City : "Houston",State : "Texas",Country : "USA"}, 
  {City : "New York",State : "New York",Country : "USA"},
  {City : "Austin",State : "Texas",Country : "USA"}, 
  {City : "London",State : "",Country : "UK"}, 
  {City : "Manchester",State :"",Country : "UK"}, 
  {City : "Paris",State : "",Country : "France"}
]; 

for (var i=0; i < jsondata.length; i++){
  var stateCountry =  jsondata[i].State ? jsondata[i].State : jsondata[i].Country;

  jsondata[i].Group = stateCountry;
}

$(document).ready(function() {
    $("#grid").kendoGrid({
        dataSource: {
            data: jsondata,
            schema: {
                model: {
                    fields: {
                        City: { type: "string" },
                        State: { type: "string" },
                        Country: { type: "string" },
                    }
                }
            },
            group: {
                field: "Group",
                dir: "asc"
            }
        },
        groupable: false,
        scrollable: true,
        columns: [
            { field: "City" },
            { field: "State" },
            { field: "Country" },
            { field: "Group", title: "State/Country", hidden: true }
        ]
    });
});