Excel-like filter bug?

[samuelParticipant]

Dear JQwidgets experts,

I’m evaluating the Excel-like fitler for future projects, however found some problem(maybe a bug) with the filter popup. In the live demo of “http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/excelfiltering.htm” the filter values in the filter popup of the second column failed to change according to the filtered rows by applying the filter of the first column.
Simple put, the table rows themselves are being filtered, but not the filter values in the filter popup. Per my understanding the different fitlers in different columns should have some kind of cascading behaviour, ie., the second filter values should reflect the results of applying the first filter, the third filter values should reflect the results of appllying the first and second filters, so on and so forth.

Please kindly help me confirm if this is a known issue or new feature that is not yet built into the product. I’d very much like to have this feature working otherwise it’s not quite possible to use it for my future projects as my customers have very big volume of data in the grids, going through all the possible filter values in each column is just too much painful. Cascading filtering is a much desired feature to work with big data volume, it should just work like MS Excel.

Best,
Samuel

[DimitarParticipant]

Hello Samuel,

Cascading filtering is generally not supported, but you can try the following customization approach: https://www.jseditor.io/?key=jqxgrid-cascading-checkedlist-filter as a workaround.

Best Regards,
Dimitar

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

[samuelParticipant]

Hi Dimitar,

Really appreciate your quick response and help, I’ll check out your workaround.
But can we expect this cascading feature built into some future releases, or is it not at all on the product roadmap ?

Thanks,
Samuel

[DimitarParticipant]

Hi Samuel,

This feature is not currently in our development plans, but I think the workaround should do fine for your purposes. It is also quite easy to implement.

Best Regards,
Dimitar

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

[afrathParticipant]

but in the work around grid ie cascading customization approach in the row based filter row the sorting, and multiple selection is not achieving so it will makes problems for multiple select?

[DimitarParticipant]

Hello afrath,

Here is the same example, but with sorting and multiple selection enabled: https://www.jseditor.io/?key=jqxgrid-cascading-checkedlist-filter-and-sort. We hope it is helpful to you.

Best Regards,
Dimitar

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

[afrathParticipant]

But i need the above example in excel mode type.

[DimitarParticipant]

Hello afrath,

As already stated, this is, unfortunately, not possible.

Best Regards,
Dimitar

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

[Author]

Posts