Column select filter implementation fail

stl99

Hi there,

I have a rather simple table but struggling to implement select filters for some of the columns. Basically everything I found here and via Google failed, probably because I just don't know how to actually implement it...

Anyway, I'd really appreciate some help with getting column selects to work with this DataTable:

jQuery(document).ready(function($) {
    $('#dtable').dataTable( {
        "bPaginate": false,
        "bLengthChange": false,
        "bFilter": true,
        "bSort": true,
        "bInfo": false,
        "bAutoWidth": false,
        "oLanguage": {
            "sLengthMenu": "Display _MENU_ records per page",
            "sZeroRecords": "Nothing found - sorry DE",
            "sInfo": "Showing _START_ to _END_ of _TOTAL_ records",
            "sInfoEmpty": "Showing 0 to 0 of 0 records",
            "sInfoFiltered": "(filtered from _MAX_ total records)"
        },
        "aoColumnDefs": [ { 
            "bSortable": false, "aTargets": [ 1 ] 
            }
        ],
        "aoColumns": [
            null,
            null,
            null,
            null,
            { "sType" : "currency" },
            { "sType" : "currency" },
            { "sType" : "currency" },
            null
        ]
    } );

Many Thanks in advance!

Cheers,
Thomas

tangerine

The individual column filters (select) example is here:

http://datatables.net/examples/api/multi_filter_select.html

stl99

Hi,

Thanks! It was actually a combination of problems, wrong file version among other things...

One more question:

If I want to modify this further - limiting the select filter to the first colum and placing it above the table - I should probably try to implement the filter plugin, right? I couldn't find any examples based on the solution you linked to...

Cheers,
Thomas

daniel_r

You can also try out my yadcf plugin for that purpose http://yadcf-showcase.appspot.com/DOM_source.html