jqxgrid filter row and filter condition

[abhargavParticipant]

We are using ‘filter row’ Filters in our jqxgrid. Can we use ‘filter condition’ Filter for one column instead of ‘filter row’ Filter?

[ivailoParticipant]

Hi abhargav,

You can’t use ‘filter condition’ Filter only for one column.
Instead you can use multiple ‘filter row’ variations of filters about that column.

filtertype - sets the filter's type. 
  'textbox' - basic text field.
  'input' - input field with dropdownlist for choosing the filter condition. *Only when "showfilterrow" is true.
  'checkedlist' - dropdownlist with checkboxes that specify which records should be visible and hidden.
  'list' - dropdownlist which specifies the visible records depending on the selection.
  'number' - numeric input field. *Only when "showfilterrow" is true.
  'checkbox' - filter for boolean data. *Only when "showfilterrow" is true.
  'date' - filter for dates.
  'range' - filter for date ranges. *Only when "showfilterrow" is true.
  'custom' - allows you to create custom filter menu widgets. *Only when "showfilterrow" is false.

      $("#jqxgrid").jqxGrid(
            {
                width: 670,
                source: dataAdapter,
                columnsresize: true,
                showfilterrow: true,
                filterable: true,
                
                selectionmode: 'singlecell',
                columns: [
                  { text: 'Name', columntype: 'textbox', datafield: 'name', width: 120 },
                  { text: 'Product', filtertype: 'checkedlist', datafield: 'productname', width: 160 },
                  { text: 'Available', datafield: 'available', columntype: 'checkbox', filtertype: 'bool', width: 67 },
                  { text: 'Ship Date', datafield: 'date', filtertype: 'date', width: 180, cellsalign: 'right', cellsformat: 'd' },
                  { text: 'Qty.', datafield: 'quantity', filtertype: 'number', width: 50, cellsalign: 'right' },
                  { text: 'Price', datafield: 'price', filtertype: 'number', cellsalign: 'right', cellsformat: 'c2' }
                ]
            });    

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[abhargavParticipant]

We would like to use filter row but we have one scenario for one column which requires to do filter like <5 or >50. Could you please suggest with the filter row to achieve this ?

[ivailoParticipant]

Hi abhargav,

Use filtertype: 'number'.
In this demo the quantity column is set this way.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[tsunilrajan1991@gmail.comParticipant]

I need to use filter row for two JQX Grid that were used in the same page but for one grid it is working fine and for other grid the filter row is not at all working. Can you help on this?

[Author]

Posts