Excel and Range Filter in same grid for different columns

[kcParticipant]

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?

[DimitarParticipant]

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/

[AjitAryaParticipant]

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.

[DimitarParticipant]

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/

[AjitAryaParticipant]

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

[DimitarParticipant]

Hi 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.

Best Regards,
Dimitar

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

[AjitAryaParticipant]

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

[DimitarParticipant]

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/

[Author]

Posts