How to filter columns in jQuery DataTables?

Question

Filter rows in DataTables as follows:

$.fn.dataTableExt.afnFiltering.push(
    function( oSettings, aData, iDataIndex ) {
        if ( aData[3] == 'ru' )
        {
            return true;
        }
        return false;
    }
);

And here is how to filter the columns? For example I have columns ( http://jsfiddle.net/JLvWu/ ):

Date   |      City1      |      City2      |      City3        |
       | Revenue | Costs | Revenue | Costs | Revenue | Costs   |

How to make so that when you filter by city there was only one city that is selected, and all other columns disappear? For example, if the user selected in the cities-filter City1, the table must be changed as follows:

Date   |      City1      |
       | Revenue | Costs |

Lukasz Koziara · Accepted Answer · 2013-01-30 11:59:34Z

1

There is datatables documentation, which show how to hide/show columns dynamically: http://www.datatables.net/examples/api/show_hide.html

answered Jan 30, 2013 at 11:59

Lukasz Koziara

4,3225 gold badges34 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to filter columns in jQuery DataTables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related