首页 > 解决方案 > DHTMLX 网格编号过滤器不使用零 (0),而是使用零作为字符串 ('0')

问题描述

我正在使用DHTMLX Grid,在列中实现数字过滤器时,它按预期工作。但如果字段值为零 (0) 并且我正在搜索零 (0),则它不起作用。

观察:如果我将零(0)放在引号中(作为字符串),它正在工作。无法更改 API 端点。

例如:如果我将以下数据作为默认网格的数据,它可以工作几个小时,但不能为cost工作。

var data = [{
    project: "Real Estate",
    owner: "Louise Fisher",
    start_date: "02/03/2018",
    end_date: "06/05/2018",
    status: "Done",
    hours: '0',
    cost: 0,
    budget: 11768,
    balance: 8180,
}];

DHTMLX 网格代码

var grid = new dhx.Grid("grid", {
        columns: [
            {
                width: 150,
                id: "project",
                header: [{ text: "Project" }, { content: "selectFilter" }],
            },
            {
                width: 150, id: "status", header: [{ text: "Status" }, { content: "selectFilter" }],
                editorType: "select",
                options: ["Done", "In Progress", "Not Started"]
            },
            { width: 150, id: "owner", header: [{ text: "Owner" }, { content: "inputFilter" }] },
            { width: 150, id: "hours", header: [{ text: "Number of hours" }, { content: "inputFilter" }] },
            { width: 150, id: "start_date", header: [{ text: "Calendar", colspan: 2 }, { text: "Start date" }], type: "date", dateFormat: "%d/%m/%Y" },
            { width: 150, id: "end_date", header: ["", { text: "End date" }], type: "date", dateFormat: "%d/%m/%Y" },

            { width: 150, id: "cost", header: [{ text: "Cost" }, { content: "inputFilter" }] },
            { width: 150, id: "budget", header: [{ text: "Budget" }, { content: "inputFilter" }] },
            { width: 150, id: "balance", header: [{ text: "Balance" }, { content: "inputFilter" }] },
        ],
        data: data,
        editing: true
    });

标签: javascriptdhtmlx

解决方案


推荐阅读