无法在网格中的切换列上搜索

Question

当我通过搜索将切换列添加到网格中时，它似乎不起作用。我已经修改了网格与搜索演示，包括一个切换。但当我尝试在上面搜索时，下拉菜单只会给我一个"是"选项，我不能为搜索子句输入任何内容。

searches: [
{ field: 'recid', caption: 'ID ', type: 'int' },
{ field: 'lname', caption: 'Last Name', type: 'text' },
{ field: 'fname', caption: 'First Name', type: 'text' },
{ field: 'email', caption: 'Email', type: 'list', options: { items: ['[e-mail]', '[e-mail]', '[e-mail]']} },
{ field: 'auth', caption: 'Auth', type: 'toggle' }
],
columns: [                
{ field: 'recid', caption: 'ID', size: '50px', sortable: true, attr: 'align=center' },
{ field: 'lname', caption: 'Last Name', size: '30%', sortable: true },
{ field: 'fname', caption: 'First Name', size: '31%', sortable: true },
{ field: 'email', caption: 'Email', size: '40%' },
{ field: 'auth', caption: 'Auth', render: 'toggle', size: '20px' }
]

jsFiddle：https://jsfiddle.net/c9r6pk7m/4/

Answer 1

虽然toggle是有效的渲染值，但它不是有效的搜索类型。

请参阅：http://w2ui.com/web/docs/1.5/w2grid.searches

您可以使用list，不过我必须承认，我不得不通过将false值映射到{id:"0", text: "No"}来"欺骗"它。

$(function () {
$('#grid').w2grid({ 
name: 'grid', 
show: { 
toolbar: true,
footer: true
},
multiSearch: true,
searches: [
{ field: 'recid', caption: 'ID ', type: 'int' },
{ field: 'lname', caption: 'Last Name', type: 'text' },
{ field: 'fname', caption: 'First Name', type: 'text' },
{ field: 'email', caption: 'Email', type: 'list', options: { items: ['[e-mail]', '[e-mail]', '[e-mail]']} },
{ field: 'auth', caption: 'Auth', type: 'list', options: { items: [{id:true, text: "Yes"}, {id:"0", text: "No"}]} }
],
columns: [                
{ field: 'recid', caption: 'ID', size: '50px', sortable: true, attr: 'align=center' },
{ field: 'lname', caption: 'Last Name', size: '30%', sortable: true },
{ field: 'fname', caption: 'First Name', size: '31%', sortable: true },
{ field: 'email', caption: 'Email', size: '40%' },
{ field: 'auth', caption: 'Auth', render: 'toggle', size: '20px' }
],
records: [
{ recid: 1, fname: 'Jane', lname: 'Doe', email: '[e-mail]', auth: true },
{ recid: 2, fname: 'Stuart', lname: 'Motzart', email: '[e-mail]', auth: true },
{ recid: 3, fname: 'Jin', lname: 'Franson', email: '[e-mail]', auth: true },
{ recid: 4, fname: 'Susan', lname: 'Ottie', email: '[e-mail]', auth: true },
{ recid: 5, fname: 'Kelly', lname: 'Silver', email: '[e-mail]', auth: true },
{ recid: 6, fname: 'Francis', lname: 'Gatos', email: '[e-mail]', auth: true },
{ recid: 7, fname: 'Mark', lname: 'Welldo', email: '[e-mail]', auth: false },
{ recid: 8, fname: 'Thomas', lname: 'Bahh', email: '[e-mail]', auth: false },
{ recid: 9, fname: 'Sergei', lname: 'Rachmaninov', email: '[e-mail]', auth: false },
{ recid: 20, fname: 'Jill', lname: 'Doe', email: '[e-mail]', auth: false },
{ recid: 21, fname: 'Frank', lname: 'Motzart', email: '[e-mail]', auth: false },
{ recid: 22, fname: 'Peter', lname: 'Franson', email: '[e-mail]', auth: false },
{ recid: 23, fname: 'Andrew', lname: 'Ottie', email: '[e-mail]', auth: false },
{ recid: 24, fname: 'Manny', lname: 'Silver', email: '[e-mail]', auth: false },
{ recid: 25, fname: 'Ben', lname: 'Gatos', email: '[e-mail]', auth: true },
{ recid: 26, fname: 'Doer', lname: 'Welldo', email: '[e-mail]', auth: true },
{ recid: 27, fname: 'Shashi', lname: 'Bahh', email: '[e-mail]', auth: true },
{ recid: 28, fname: 'Av', lname: 'Rachmaninov', email: '[e-mail]', auth: true }
]
});    
});

https://jsfiddle.net/c9r6pk7m/9/