jQWidgets Forums

jqxversion = v3.7.1

I have button called search, on click of this button we are pulling the data from source and binding to JQXGrid.

When we select the filter value as “null” or “not null” from the numeric column, then upon click of the search button the value 0 is displaying unnecessarily in numeric column (search box) though the data loaded properly.

Search button click has the following JQXgrid settings.

$(errorReportSearchGrid).jqxGrid(
{
virtualmode: true,
rendergridrows: function (obj) {
return obj.data;
},
width: ‘100%’,
enablebrowserselection: true,
source: dataAdapter,
columnsresize: true,
autoshowfiltericon: true,
showfilterrow: true,
filterable: true,
pagesize: 50,
sortable: true,
pageable: true,
pagermode: ‘simple’,
pagerbuttonscount: 10,
columnsresize: true,
selectionmode: ‘multiplecellsextended’,
pagesizeoptions: [’10’, ’20’, ’50’, ‘100’],
columns: [
{ text: ‘ID’, columntype: ‘textbox’, filtertype: ‘number’, datafield: ‘ID’, width: ‘10%’, createfilterwidget: jqxGridHelper.restrictNumberFilter },
{ text: ‘Error’, columntype: ‘textbox’, filtertype: ‘input’, datafield: ‘Error’, width: ‘38%’ },
]
});

Please let me know on this