jQuery UI Widgets Forums Grid Excel and Range Filter in same grid for different columns

This topic contains 7 replies, has 3 voices, and was last updated by  Dimitar 7 years ago.

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

  • kc
    Participant

    For certain columns I want an Excel type filter and for number columns I want to non-excel filter where I can put in the condition “less than”, “greater than”, ….

    For the excel filter, filtermode: ‘excel’, I want to have certain columns use the Excel type filter and other columns allow for a range. For example, if I have a grid with 10,000 rows and a column is a number, I want to use the range filter “less than”, “greater than”, …

    What would be best is if the Excel type filter (Check List) and the range type filter can be defined for each column
    http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/excelfiltering.htm

    See: Quantity column for the numeric range input. If Quantity “greater than” 10 AND Quantity “less than” 50
    http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/filtering.htm

    Also, in the Excel filter they have a Apply and Clear button for each column. Is there an Apply and Clear for non-excel filtermode?


    Dimitar
    Participant

    Hello kc,

    The requested feature will be available in the next version of jQWidgets. As for the buttons – “Filter” and “Clear” are available in both filter modes even now, as you can see from the demos.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/


    AjitArya
    Participant

    Any update on this?

    I want to use the filtermode: ‘excel’ on all columns except the date columns (I got 5) with filtertype: ‘range’.

    What should I do?

    On enabling the filter row, all the columns start to show text boxes in the filter row and excel like filtering is lost.

    EDIT:

    Important Note: I have empty cells as well in the date columns. Not sure how the range filtering would work with that. Please help.

    • This reply was modified 7 years, 1 month ago by  AjitArya.
    • This reply was modified 7 years, 1 month ago by  AjitArya.

    Dimitar
    Participant

    Hello AjitArya,

    filtermode: 'excel' is applicable only to the filter menu. However, showfilterrow: true disables the filter menu and shows the filter row instead. As a workaround, you can set filtertype: 'checkedlist' to your non-date columns (it is similar to what filtermode: 'excel' offers). An example is the “Product” column in the following demo: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/filterrow.htm?light.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/


    AjitArya
    Participant

    Hi Dimitar,

    Thanks for replying. Before I posted here, I had already tried setting the flitertype: ‘checklist’, and what happened was that the filterrow showed dropdowns on each column with data and checkboxes but for some reason didn’t gave the filter and clear buttons like the filtermode: ‘excel’ had and my client didn’t liked those drop downs and a separate row to use filtering.

    It would be great if MS Excel style ‘DATE’ filtering can be done with ‘excel’ filtermode.

    Another thing I noticed is that in the excel filtermode, the filter menu for date columns (automatically shows checkedlist when showfilterrow was false) didn’t apply the date formatting ‘d’ that I had applied on the grid cells. I do understand that the cellsformat: ‘d’ is only meant for cells but this would have also been helpful as per a user perspective if the cells formatting could have taken into account on the filter menu items as well. Coz right now the values in the cells display in a different format and in the filter menu they look different.

    Do you know if both of these things + cascade filtering are in the pipeline for any future releases?

    Or if there is a workaround.

    Thanks

    • This reply was modified 7 years ago by  AjitArya.

    Dimitar
    Participant

    Hi AjitArya,

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/


    AjitArya
    Participant

    Hi Dimitar,

    If not that kind of date filtering then at least excel filtermode should be able to support date range filtertype, right? but I didn’t see that either.

    That Cascade filtering is what I was looking for. Thanks for sharing that. I hope the clear filter functionality of the excel filtermode clear button will still work as expected even with this cascade filter.

    Thanks
    Ajit


    Dimitar
    Participant

    Hi Ajit,

    Unfortunately, filtermode: 'excel' does not provide a date range filter type. Such an option is available in other filter modes, though (filtermode: 'default' and the filter row with filtertype: 'range').

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

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

You must be logged in to reply to this topic.