jQuery UI Widgets Forums Grid jqxgrid filter row and filter condition

This topic contains 4 replies, has 3 voices, and was last updated by  tsunilrajan1991@gmail.com 4 years, 9 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author

  • abhargav
    Participant

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


    ivailo
    Participant

    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

    • This reply was modified 8 years, 11 months ago by  ivailo.

    abhargav
    Participant

    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 ?


    ivailo
    Participant

    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

    jqxgrid filter row and filter condition #106704

    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?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.