在Kendo Grid数据源中针对可能为空的列进行null值处理,例如:
var gridDataSource = new kendo.data.DataSource({ data: [ { name: "John Doe", age: 30 }, { name: null, age: 25 }, { name: "Jane Smith", age: null } ], schema: { model: { fields: { name: { type: "string" }, age: { type: "number" } } } } });
//将null值处理为"" var grid = $("#grid").kendoGrid({ dataSource: gridDataSource, columns: [ { field: "name" }, { field: "age", template: "#= age || ''#" } ] });
在列筛选时,忽略值为null的行,例如:
//忽略值为null的行 var grid = $("#grid").kendoGrid({ columns: [ { field: "name", filterable: { extra: false } }, { field: "age", filterable: { extra: false } } ], dataSource: { data: [ { name: "John Doe", age: 30 }, { name: null, age: 25 }, { name: "Jane Smith", age: null } ], filter: function(dataItem) { return dataItem.name !== null && dataItem.age !== null; } } });