Search
11428 results 2121-2130
Forum
- 5th Aug 2015Integrating DataTables with own search filter cause display issueI 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?
- 29th Jul 2015filter column customizeHow 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" } ] });
- 13th Jun 2015Cannot filter on column if it is already ordered in server side tableIn 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?
- 4th May 2015Table will not redraw after filter or searchfrom the table. The filtering callback seems to work
- 29th Apr 2015Search (Filter) not working.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 ); } }); } );
- 21st Apr 2015Column Filter value - Server SideHello, 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
- 9th Apr 2015How can users filter an exact parameter in text search filter?ie. search for "7" and get back all with exactly 7 instead of get back all with 7, 37, 17, 77, etc.
- 2nd Apr 2015Label "Search" always on the top of the Filter inputHello, 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
- 24th Mar 2015Creating custom sort filterHi, 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?
- 21st Mar 2015add Search API regex filter for datatables with yadcfadd Search API regex filtering for my table without