Excel Filter

[sunnyParticipant]

Hello Team,

In jqxGrid I have a column with comma seperated values and I am using excel filters. So when try to filter a value present in comma seperated list, data is not getting filtered. Any solution on this?

Regards,
Sunny

[Peter StoevKeymaster]

Hi Sunny,

The Grid filters by cell value, not by what’s displayed with cells renderer.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[sunnyParticipant]

Hi,

I am not using cell renderer. Cell value itself contains comma seperated list.

Regards,
Sunny

[Peter StoevKeymaster]

Hi Sunny,

The Excel Filter filters by Exact Match with the Cell Value. That is how it works i.e it makes “==” if this returns true, it displays the cell, otherwise it does not. From this explanation, I cannot tell what’s wrong with your code. Share a jsfiddle.net sample so someone can be able to test your case.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[sunnyParticipant]

Hi,

Please find the sample link – http://jsfiddle.net/LYLvA/134/
Suppose I filtered first column with ‘test’ then it should show all the rows as each row contains test but it is showing only one row. Can I give a ‘contains’ as a filter condition instead of ‘===’?

Regards,
Sunny

[Peter StoevKeymaster]

Hi Sunny,

No. It makes Exact Match and works correctly within the provided sample. If you’re looking for Contains or other types, don’t turn on the Excel Filter mode.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts