Search

table that uses column filtering as per https://datatables.net/release-datatables/examples/api/multi_filter_select.html Some

I am using backbone and jquery datatable.I am loading data from server side .Every thing is working fine except column filter.I am not getting any error also. self.oTable = $('#example').dataTable({ "bDestroy": true, "sScrollX": "965px", "bProcessing": true, "bServerSide": true, "bPaginate": true, "bLengthChange": false, "bFilter": false, "bInfo": true, "sDom": 'Rlfrtip', fnDrawCallback: function( oSettings ) { alert( 'DataTables has redrawn the table' ); }, "aoColumns": columns, "aoColumnDefs": [ { "sClass": "dpass", "aTargets": [ 0 ] } ], }).columnFilter() this.oTable.fnBuildCustomeHead(); setTimeout(function() { var foot = $("#example").find('tfoot'); if (!foot.length) foot = $('<tfoot id="tfoot">').prependTo("#example"); $('#example thead tr ').each(function (id,text) { $('#example thead').append(text); }); $('#example tfoot').append("<tr></tr>"); $('#example thead tr th').each(function (id,text) { if(id!==0) $('#example tfoot tr').append("<th>"+text.getAttribute('aria-label').split(':')[0]+"</th>"); }); }, 5000); Below is my html code <table cellpadding="0" cellspacing="0" border="0" id="example"> </table> Please help Thanks

i would like my table to display only data related to the user that is loggged in employer's id. when i hard code it, it works but how do i make it dynamic? my php code below works, how do i make it work without hard coding the value. ->where($key = "active", $value = 'yes', $op = "=") ->where($key = "employer_id", $value = "344" , $op = "=") ->process( $_POST ) ->json();

I'm trying to dynamically insert search by column and the header, but it is appearing only search by column. What is wrong in my code? var dataSet = [ ['Trident', 'Internet Explorer 4.0', 'Win 95+', '4', 'X'], ['Trident', 'Internet Explorer 5.0', 'Win 95+', '5', 'C'], ['Trident', 'Internet Explorer 5.5', 'Win 95+', '5.5', 'A'], ['Trident', 'Internet Explorer 6', 'Win 98+', '6', 'A'], ['Trident', 'Internet Explorer 7', 'Win XP SP2+', '7', 'A'], ['Trident', 'AOL browser (AOL desktop)', 'Win XP', '6', 'A'], ['Gecko', 'Firefox 1.0', 'Win 98+ / OSX.2+', '1.7', 'A'], ['Gecko', 'Firefox 1.5', 'Win 98+ / OSX.2+', '1.8', 'A'], ['Gecko', 'Firefox 2.0', 'Win 98+ / OSX.2+', '1.8', 'A'], ['Gecko', 'Firefox 3.0', 'Win 2k+ / OSX.3+', '1.9', 'A'], ['Gecko', 'Camino 1.0', 'OSX.2+', '1.8', 'A'], ['Gecko', 'Camino 1.5', 'OSX.3+', '1.8', 'A'], ['Gecko', 'Netscape 7.2', 'Win 95+ / Mac OS 8.6-9.2', '1.7', 'A'], ['Gecko', 'Netscape Browser 8', 'Win 98SE+', '1.7', 'A'], ]; var $table = $("table#column-filtering"); oTable = $table.dataTable({ "aaData": dataSet, "aoColumns": [ { "bSearchable": true, "sTitle": "Engine", "sClass": "center", "bSortable": true }, { "sTitle": "Browser" }, { "sTitle": "Platform" }, { "sTitle": "Version", "class": "center" }, { "sTitle": "Grade", "class": "center" } ], "oLanguage": { "sProcessing": "Processando...", "sLengthMenu": "Mostrar _MENU_ registros", "sZeroRecords": "<div style='text-align: center;font-weight: bold; height: 50px; line-height: 50px;'>Não foram encontrados resultados</div>", "sInfo": "Mostrando de _START_ até _END_ de _TOTAL_ registros", "sInfoEmpty": "Mostrando de 0 até 0 de 0 registros", "sInfoFiltered": "", "sInfoPostFix": "", "sSearch": "Buscar:", "oPaginate": { "sFirst": "Primeiro", "sPrevious": "Anterior", "sNext": "Seguinte", "sLast": "Ãltimo" } } }).columnFilter({ sPlaceHolder: "head:before", aoColumns: [ { type: "select", values: ['Gecko', 'Trident', 'KHTML', 'Misc', 'Presto', 'Webkit', 'Tasman'] }, { type: "text" }, null, { type: "number" }, { type: "select" } ] });

I know you can do this with server side processing turned on but that looks too tricky for me right now. So please look at this code. http://jsfiddle.net/o00yLj47/ you will see what isn't working. Any ideas guys? This datatable is in a modal. Behind the modal is a different datatable as well with a different name so I don't think that would cause conflicts.

Here is my example table. Artist | Service | Cash | Credit | Expense | Date | Description A | Services | 400 | 200 | 100 | 09/29/2014 | user test. jonn | test | 100 | 0 | 0 | 09/29/2014 | sample sale Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose Showing 1 to 4 of 4 entries Total Cash: $600 Total Credit: $250 Total: $750 WHEN the search filter(Steve) is applied,Total Cash, Credit, Total should get calculated once again. How can we do this? Artist | Service | Cash | Credit | Expense | Date | Description Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose Showing 1 to 2 of 2 entries (filtered from 4 total entries) Total Cash: $600 Total Credit: $250 Total: $750 Please let me know how to implement this. Thanks, AK

Hello, we are using this Code: aoColumns: [ null, { sSelector: "#filter_a", type: "date-range" }, { sSelector: "#filter_b", type: "select", values: [ ] }, null, null, null, null, null, null, null, null ] }); var $options = $("#filter_b").find("select > option").clone(); $('#pilotnames') .empty() .append($options); It will output all Names. How it is possible that we change select box to a special value who no one could change? I mean how it is possible to insert the filter_b value with no selector? So How it is possible to replace the type "select" to a fix value?

Hi, I've added sPlaceHolder: "head:before" for datatable. After adding the alignment between column header and body will be mismatched. Can you please let me know what to do for alignment? Kindly waiting for your response. Thanks, Santosh

Is there any example for datatable columnFilter for special characters?

For example we have a value "Unclassified" that always appears at the bottom when a user searches "un" due to the default order being ascending. As "unclassified" includes the characters "un" earlier in the string than, say, "duncan" I'd like it to appear at the top. All of the examples I've been looking at apply custom sorting to the table regardless of whether or not it has been filtered.