Search

ColVis and select dropdown filters with datables 1.7. I

Hello I'm using Datatables with PostgreSQL for my database and the example processing file http://www.datatables.net/development/server-side/php_postgres. My problem is that I have a field which is of date type in my PostgreSQL table and the example file says I need to modify it for all other types of data except string. I probably need to cast the date to string type as I understand. Can you show me how to implement that ? Is there any script / modification / plugin that already solves this ? Thanks for a great script!

a little trouble with filtering This is the problem

Hey, I want to global filter/search from index.php and get the value to datatable search input in search.php. Hope you get what i want. And is it possible to make column rows linkable? I'm outputting names and want to add a html/php code to the names. Regards, SeDo

Hi guys, I have a table with datatables and I fill it with checkboxes. But when I search for something and then POST the data, not all checkboxes get POSTED... I want all checkboxes to POST...

Hello, a small fix to use HTML in Tables if you using this example code: "DataTables individual column filtering example (using select menus) " function fnCreateSelect( aData ) { var r='', i, iLen=aData.length; for ( i=0 ; i/g,""); r += ''+str+''; } return r+''; }

How can I add multi-selects as filters?

check the searching and filtering option.Rest of the functionality

Hi, i have dropdownlist out of data table, depends on user selection in dropdownlist then datatable will be displayed records.. It's working for only first selections for ex: in dropdownlist values x,y and z. if i select "x" then datatable is displaying accroding "x" related. again if i select "y" or "z"then it is displaying messagebox " DataTables warning: Unable to re-initialise DataTable. Please use the API to make any configuration changes required." Code: $(function() { $("#Users").change(function() { ' Users -- dropdownlist id var selectedItem = $(this).val(); //ready function var gaiSelected = []; var oTable; $(document).ready(function() { oTable = $("#tblService1Index").dataTable({ "bJQueryUI": true, "oLanguage": { "sLengthMenu": 'Display ' + '10' + '20' + '30' + '40' + '50' + 'All' + ' records' }, "sPaginationType": "full_numbers", "fnRowCallback": function(nRow, aData, iDisplayIndex) { if (jQuery.inArray(aData[0], gaiSelected) != -1) { $(nRow).addClass('row_selected'); } return nRow; }, "aoColumns": [ { "bSortable": true, "bVisible": false }, { "bSortable": true, "fnRender": function(aobj) { return '' + aobj.aData[1] + ''; } }, { "bSortable": true }, { "bSortable": true }, { "bSortable": true }, { "bSortable": true }, { "bSortable": true, "bVisible": false }, { "bSortable": true }, { "bSortable": true, "fnRender": function(aobj) { return 'Subscribe'; } }], "sAjaxSource": '' + selectedItem }); }); }); }); Plz help me on this.. Thank You, Narsa Reddy.

I have got column filtering with select working fine,