JQGrid filter toolbar example

by parramorej

HTML

<script src="https://oss.maxcdn.com/jqgrid/4.6.0/jquery.jqGrid.min.js"></script>
<script src="https://oss.maxcdn.com/jqgrid/4.6.0/i18n/grid.locale-en.js"></script>
<link rel="stylesheet" href="https://oss.maxcdn.com/jqgrid/4.6.0/css/ui.jqgrid.css">
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/themes/redmond/jquery-ui.css">
<table id="test1"></table>

JavaScript

$("#test1").jqGrid({
	datatype: "local",
	height: 250,
   	colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
   	colModel:[
   		{name:'id',index:'id', width:60, sorttype:"int"},
   		{name:'invdate',index:'invdate', width:90, sorttype:"date"},
   		{name:'name',index:'name', width:100},
   		{name:'amount',index:'amount', width:80, align:"right",sorttype:"float"},
   		{name:'tax',index:'tax', width:80, align:"right",sorttype:"float"},		
   		{name:'total',index:'total', width:80,align:"right",sorttype:"float"},		
   		{name:'note',index:'note', width:150, sortable:false}		
   	],
   	multiselect: true,
   	caption: "Manipulating Array Data"
});
$("#test1").jqGrid('filterToolbar',
                   {
  autosearch: true,
  stringResult: true,
  searchOnEnter: true,
  defaultSearch: "cn"
}
);var mydata = [
		{id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
		{id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
		{id:"3",invdate:null,name:"test3",note:"note3",amount:null,tax:null,total:null},
		{id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
		{id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
		{id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
		{id:"7",invdate:null,name:"test",note:"note",amount:null,tax:null,total:null},
		{id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
		{id:"9",invdate:null,name:"test3",note:null,amount:"400.00",tax:"30.00",total:"430.00"}
		];
for(var i=0;i<=mydata.length;i++)
	$("#test1").jqGrid('addRowData',i+1,mydata[i]);