Display row, where column has specific data

carlyip

Hi, i want to make a button that has a dropdown, that can display all rows data with specifc data of column

https://pasteboard.co/sB6zCwQKyGLu.png

Etc, display all rows where the column "Technology" is equal to something

how can i make that

allan

Use a column filter - column().search().

Allan

carlyip

Hi i have embeded this lines of code and commented previous code

var table = $('#table-item').DataTable();
 
table.columns( '.select-filter' ).every( function () {
    var that = this;
 
    // Create the select list and search operation
    var select = $('<select />')
        .appendTo(
            this.footer()
        )
        .on( 'change', function () {
            that
                .search( $(this).val() )
                .draw();
        } );
 
    // Get the search data for the first column and add to the select list
    this
        .cache( 'search' )
        .sort()
        .unique()
        .each( function ( d ) {
            select.append( $('<option value="'+d+'">'+d+'</option>') );
        } );
} );

but my page oni display this, nothing display or changed
https://pasteboard.co/bIjzwFT6wY8g.png

carlyip

This is my previous code

        $(document).ready( function () {
    $('#table-item').DataTable();
    } );

kthorngren

This code is appending to the footer:

        .appendTo(
            this.footer()
        )

But your table doesn't have a tfoot. Define a footer for your table.

Kevin