Search

hi guys, here's my code (in a function i created called "drawTable"): var oTable = $('#exampleTable').dataTable({ "bJQueryUI": false, "aaData": external, "bFilter": true, "bPaginate": false, "aoColumns": [{ "mDataProp": null, 'bSortable': false, 'aTargets': [-1], "sClass": "control center", "sDefaultContent": '' }, { "mDataProp": "Utente" }, { "mDataProp": "Matricola" } ,{ "mDataProp": "Cellulare", "bSortable":false }, { "mDataProp": "CDC" }, { "mDataProp": "Totale" } ], "oLanguage": { "sInfo": "_TOTAL_ Occorrenze", "sSearch": "<span>Ricerca</span> _INPUT_" //search }, "aaSorting": [ ], }); $('#exampleTable tbody td .addImg').live('click', function() { var nTr = $(this).parents('tr')[0]; var nTds = this; if (oTable.fnIsOpen(nTr)) { /* This row is already open - close it */ this.src = "/Work/corse_taxi/PublishingImages/add-128.png"; oTable.fnClose(nTr); } else { /* Open this row */ var rowIndex = oTable.fnGetPosition($(nTds).closest('tr')[0]); var detailsRowData = external[rowIndex].details; this.src = "/Work/corse_taxi/PublishingImages/minus-128.png"; oTable.fnOpen(nTr, fnFormatDetails(iTableCounter, detailsTableHtml), 'details'); oInnerTable = $("#exampleTable_" + iTableCounter).dataTable({ "bJQueryUI": false, "bFilter": false, "aaData": detailsRowData, "aoColumnDefs": [ { "fnRender": function ( oObj ) { return '<a target=\'_blank\' href=\''+siteUrl+'/_layouts/listform.aspx?PageType=4&ListId={6880B218-0558-4F67-BD5E-DA6B7C2E386C}&ID='+oObj.aData.Identificativo+'&ContentTypeID=0x0100CADA4096A22F46428537898EE3AB1D3F00C5E06CE98616664DB47FBCABB2A70CB8\'><div class=\'divMagnify\'><img id=\'magnify\' src=\'/Work/corse_taxi/PublishingImages/magnifying-glass-icon-28.png\'></img></div></a>'; }, "aTargets": [6] }, ], "aoColumns": [{ "mDataProp": "DataChiusura" }, { "mDataProp": "Partenza", "bSortable":false }, { "mDataProp": "Arrivo", "bSortable":false }, { "mDataProp": "Mese", "bSortable":false }, { "mDataProp": "Anno", "bSortable":false }, { "mDataProp": "Totale" }, { "mDataProp": "Identificativo", "bSortable":false } ], "aaSorting": [ ], "bPaginate": false, "oLanguage": { "sInfo": "_TOTAL_ Occorrenze" }, "fnRowCallback": function(nRow, aData, iDisplayIndex, iDisplayIndexFull) { return nRow; } }); iTableCounter = iTableCounter + 1; } }); i set a button called "reset" which would essentially call again the drawTable function, and indeed it does but then, when i click on the expanding button to showing the details table it gives me the "b is null" (and on top level something like: impossible to retreive the property aoOpenRows of a null) error. any clue? i'm using: http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.0/jquery.dataTables.min.js thank you, i'm almost to give up :(

I have a vanilla DataTable based on a Doctrine entity Chemical: $(document).ready(function() { $('#chemical).DataTable( { "processing": true, "serverSide": true, "ajax": ""/CIR/web/app_dev.php/chemical/filter" } ); } ); The entity is linked to many other entities that don't need to be displayed in the table. But they would be extremely useful for limiting the result-set. For example, a user may wish to see only those Chemicals that have Supplies which have Items. For overhead reasons, I'd prefer not to include these other entities in a query unless I have to. What I'd like to do is modify the request parameters that Datatables sends by including the field values from a separate form. Can I set option ajax = function(){ }? What is passed to the function? Is there a preferred way of modifying Datatables request parameters?

https://datatables.net/examples/advanced_init/dom_multiple_elements.html I cannot understand why this is not working. I THINK it might be related to bootstraps code but i cannot actually see "row" being applied anyway on the rows. For some reason each of these elements (no matter how much i try to force them together) do not want to just sit together on one row. This is the best I have got '<"searcharea col-md-5"f> <"col-md-2" l> <"exportButtons col-md-5"B> <"col-md-12"t><"col-md-6"i><"col-md-6"p>', But I want the Length control to sit nicely next to the filter/search control. If I do this '<"searcharea col-md-7"fl> <"exportButtons col-md-5"B> <"col-md-12"t><"col-md-6"i><"col-md-6"p>', then it puts the F and L together but on new lines on the left, then the Button controls on the right! It's driving me insane.

Is it possible to have the dropdown filtering based on a search key term like the example below. Thanks. http://sandbox.scriptiny.com/tinytablev3/

I have 5 separate tables on my page with the same columns structure. In this page I need to create a search box that would perform search query in all given tables but in the same column. I used reg. exp. Search API functions which are described here: https://datatables.net/examples/api/regex.html This is my jquery code: function filterColumn ( i ) { $('.table').DataTable().column( i ).search( $('#col'+i+'_filter').val(), $('#col'+i+'_regex').prop('checked'), $('#col'+i+'_smart').prop('checked') ).draw(); } $(document).ready(function() { $('.table').DataTable({ }); $('input.column_filter').on( 'keyup click', function () { filterColumn( $(this).parents('tr').attr('data-column') ); } ); } ); This code works fine and it really performs the search query in columns but only in the 1st table. But I want it to make the same search query in all my 5 tables. What should I change in this code? Please, help.

I have a datatable with a donut chart. When I click a section I want to reset the pagination of the table. $("#myForm").submit(function(e) { table.fnPageChange(0); table.fnReloadAjax(); return false; }); Something like this may work?

inside that table, without filtering anything before. Anyone with

I am using datatables with ajax-datatables-rails in my Rails 4 site. The table is working beautifully, but it currently only shows selectable unique data from the first page (10 results per page). I would like to show all but cannot find any documentation on this, which is needed due to my lack of proficiency with javascript. I've also switched from the coffeescript file to in-page javascript due to an issue with coffeescript not liking the ", true, false" bit on line 16. Still not working though. Here is the javascript in my index view: $(document).ready(function() { $('#search-table').DataTable( { processing: true, serverSide: true, ajax: $('#search-table').data('source'), initComplete: function () { this.api().columns().every( function () { var column = this; var select = $('<select><option value=""></option></select>') .appendTo( $(column.footer()).empty() ) .on( 'change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); column .search( val ? '^'+val+'$' : '', true, false ) .draw(); } ); column.data().unique().sort().each( function ( d, j ) { select.append( '<option value="'+d+'">'+d+'</option>' ) } ); } ); } } ); } );

I've linked both .js file and .css file in my code as below ,but it shows the grid with my data but its not showing pagination/filter/sorting.. Am using a visual webpart and below is my code for ascx file <script type="text/javascript"> $(document).ready(function () { $('#GridView1').dataTable({ "sPaginationType": "full_numbers", "aaSorting": [], "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]], "pageLength": 14, //"scrollY": "200px", //"scrollCollapse": true, "sDom": 'T<"clear">lfrtip', "tableTools": { "sSwfPath": "http://www.datatables.net/release-datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf" }, /* Disable initial sort */ "bDestroy": true, "bProcessing": true, "bpaging": false, "bSort": false }); }); </script> Please help

DataTable example where the filtering functionality seems not to