March 9, 2015 at 11:19 pm Excel and Range Filter in same grid for different columns #68229
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
See: Quantity column for the numeric range input. If Quantity “greater than” 10 AND Quantity “less than” 50
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?March 10, 2015 at 6:19 am Excel and Range Filter in same grid for different columns #68234
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.
http://www.jqwidgets.com/April 21, 2017 at 8:41 pm Excel and Range Filter in same grid for different columns #93070
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.
Important Note: I have empty cells as well in the date columns. Not sure how the range filtering would work with that. Please help.May 2, 2017 at 7:00 am Excel and Range Filter in same grid for different columns #93237
filtermode: 'excel'is applicable only to the filter menu. However,
showfilterrow: truedisables 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.
http://www.jqwidgets.com/May 3, 2017 at 9:47 pm Excel and Range Filter in same grid for different columns #93283
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.
May 4, 2017 at 5:13 am Excel and Range Filter in same grid for different columns #93285
- This reply was modified 6 years, 7 months ago by AjitArya.
- Unfortunately, date filtering in the manner shown here is not available.
- We do not experience such an issue with the latest version of jQWidgets (4.5.1). You can find a working example here: http://jsfiddle.net/jqwidgets/LYLvA/ (try changing the cellsformat of column “Order Date”).
- Cascade filtering is discussed in the following topic: http://www.jqwidgets.com/community/topic/cascaded-filter-in-jqxgrid/. Please refer to it.
http://www.jqwidgets.com/May 5, 2017 at 7:23 pm Excel and Range Filter in same grid for different columns #93328
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.
AjitMay 9, 2017 at 5:22 am Excel and Range Filter in same grid for different columns #93356
You must be logged in to reply to this topic.