Search

I have a standard jQuery ajax request to my own PHP code to return a formatted HTML code $.ajax({ type: "POST", url: "ajaxSearch.php", data: $('#form').serializeArray(), dataType: "json", timeout: 10000, success: function(returnData) { if(returnData.Type == 'success') { $('#tbody').html(returnData.Message); $('#table').DataTable({ paging: true, searching: false, lengthMenu: [[5, 10, 20, 50, 100], [5, 10, 20, 50, 100]], iDisplayLength: 5, columnDefs: [{ orderable: true, targets: -1 }] }); } }, }); I have initialized the table: <table id="table"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Action</th> </tr> </thead> <tbody id="tbody"> </tbody> </table> After returnData.Message is embedded into #tbody, the table will look like this: <table id="table"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Action</th> </tr> </thead> <tbody id="tbody"> <tr> <td>1</td> <td>John Smith</td> <td><a href="edit.php?id=1">Edit</a></td> </tr> <tr> <td>2</td> <td>John Doe</td> <td><a href="edit.php?id=2">Edit</a></td> </tr> </tbody> </table> Then I use DataTables to beautify my table. Also providing searching and paging function. But there is a problem, my custom form #form may affect the returnData.Message result. When DataTables is being called again, even though there is nothing inside returnData.Message. I clicked on the table, the table will show all non-filtered results. How can I fix this?

How do I add html codes on filters columns ? var table = $('#datatable_orders').dataTable().columnFilter({ sPlaceHolder: "head:after", aoColumns: [ { type: "label" }, { type: "label" }, { type: "date-range" }, { type: "text" }, { type: "text" }, { type: "number-range" }, { type: "number-range" }, { type: "select" }, { type: "label" }, { type: "label" } ] });

In the table where processing is done by serverside, If a column is ordered already, i am not able to search on the same column. The same problem does not happen on static table or ajax table. If column is not previously ordered it is working fine. For e.g. if I have ordered by 2nd column, I cannot apply search on the same column. The data is not getting passed to the serverside. Is there a fix for this issue?

from the table. The filtering callback seems to work

Result of query: {"error":"Unknown field: (index 0)","data":[]} this is my code: $(document).ready(function() { var inputFilter = $('#example').dataTable( { order: [[ 8, "desc" ]], processing: true, serverSide: true, ajax: { url: "/complex/examples/php/join.php", type: 'GET' }, columns: [ { data: null, defaultContent: '', orderable: true }, { data: "shows_video.id" }, { data: null, render: function( data, type, full, meta ){ var youtube = data.shows_video.youtube ? '<i class="fa fa-youtube" style="color:#24CA00;"></i>' : '<i class="fa fa-youtube"></i>'; var top = data.shows_video.top ? '<i class="fa fa-home" style="color:#24CA00;"></i>' : '<i class="fa fa-home"></i>'; var recommended = data.shows_video.recomended ? '<i class="fa fa-bookmark" style="color:#24CA00;"></i>' : '<i class="fa fa-bookmark"></i>'; var video = data.shows_video.file ? '<i class="fa fa-film" style="color:#FFC200;"></i>' : '<i class="fa fa-film"></i>'; var image = data.shows_video.img ? '<i class="fa fa-camera" style="color:#24CA00;"></i>' : '<i class="fa fa-camera"></i>'; return '<span title="YouTube">'+ youtube +'</span> <span title="რეკომენდებული">'+ recommended +'</span> <span title="მთავარი სლაიდერში">'+top+'</span> <span title="YouTube">'+ video +'</span> <span title="YouTube">'+ image +'</span>'; } }, { data: "shows.title_ge" }, { data: "shows_video.title_ge" }, { data: "shows_video.title_en" }, { data: "shows_video.viewscount" }, { data: null, defaultContent: '', orderable: true }, { data: "shows_video.adddate" } ], } } ); $('#example_filter input').addClass('datetime').css({'width': '220px'}); $('.datetime').datepicker({ dateFormat: "yy-mm-dd", onSelect: function(dateText, inst){ var date = $(this).val(); inputFilter.fnFilter( date ); } }); } );

Hello, I couldn't find this information anywhere. I am trying to achieve server side column filtering. What is the object name of filtered column sent to server ? (eg sSearch for general search) Thanks

ie. search for "7" and get back all with exactly 7 instead of get back all with 7, 37, 17, 77, etc.

Hello, I do not know why, but the label "Suchen" is always on the top of the Input "search" I want it left beside as seen in other examples. Any idea? < div id="example_wrapper" class="dataTables_wrapper no-footer"> Suchen

Hi, I've come across many tutorials but none is similar to my case. I'm trying to fire sort outside of dataTables: Code looks something like this: //init window.table = $('.table').dataTables(); //call sort from the custom dropdown window.table.fnSort([[$("#tableSort option:selected").val(), 'desc']]); So I get by which parameter to sort. The problem now is that the default functionality of fnSort is not enough for me as I'm trying to sort a date, and some rows don't have a date but have "-" instead. So I'd like to push those with "-" character to the bottom of results, something like this: loopThroughRows -> if(row == "-") { skip it and put it on the end } Help would be much appreciated. How can I create a custom function to call the same was as fnSort?

add Search API regex filtering for my table without