Html Grid

Set the filtermode property of the jqxGrid. Author: http://jqwidgets.com

by Louis Tsang

HTML

<script src="https://jqwidgets.com/public/jqwidgets/jqx-all.js"></script>
<link rel="stylesheet" href="https://jqwidgets.com/public/jqwidgets/styles/jqx.base.css">
<link rel="stylesheet" href="https://jqwidgets.com/public/jqwidgets/styles/jqx.energyblue.css">
<script src="https://jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/generatedata.js"></script>
<div id="jqxgrid"></div>

JavaScript

var data = generatedata(500);
 var source = {
   localdata: data,
   datafields: [{
     name: 'firstname',
     type: 'string'
   }, {
     name: 'lastname',
     type: 'string'
   }, {
     name: 'productname',
     type: 'string'
   }, {
     name: 'date',
     type: 'date'
   }, {
     name: 'quantity',
     type: 'number'
   }, {
     name: 'price',
     type: 'number'
   }],
   datatype: "array"
 };
 var addfilter = function() {
   var filtergroup = new $.jqx.filter();
   var filter_or_operator = 1;
   var filtervalue = 'Beate';
   var filtercondition = 'equal';
   var filter1 = filtergroup.createfilter('stringfilter', filtervalue, filtercondition);
   filtervalue = 'Andrew';
   filtercondition = 'equal';
   var filter2 = filtergroup.createfilter('stringfilter', filtervalue, filtercondition);
   filtergroup.addfilter(filter_or_operator, filter1);
   filtergroup.addfilter(filter_or_operator, filter2);
   // add the filters.
   $("#jqxgrid").jqxGrid('addfilter', 'firstname', filtergroup);
   // apply the filters.
   $("#jqxgrid").jqxGrid('applyfilters');
 }
 var adapter = new $.jqx.dataAdapter(source);
 $("#jqxgrid").jqxGrid({
   width: 500,
   theme: 'energyblue',
   filtermode: 'excel',
   source: adapter,
   filterable: true,
   sortable: true,
   ready: function() {
     addfilter();
   },
   autoshowfiltericon: true,
   columns: [{
     text: 'First11 Name',
     datafield: 'firstname',
     width: 90
   }, {
     text: 'Last Name',
     datafield: 'lastname',
     width: 90
   }, {
     text: 'Product',
     datafield: 'productname',
     width: 170
   }, {
     text: 'Order Date',
     datafield: 'date',
     width: 160,
     cellsformat: 'dd-MMMM-yyyy'
   }, {
     text: 'Quantity',
     datafield: 'quantity',
     width: 80,
     cellsalign: 'right'
   }, {
     text: 'Unit Price',
     datafield: 'price',
     cellsalign: 'right',
     cellsformat: 'c2'
   }]
 });