Search

I've link both .js file and .css file in my code as below, it shows the grid with my data but its not showing pagination/filter/sorting..

I have intranet page that seems to not want to work properly on internet explorer. I used my render code on the live.datatables page and it works correctly even on internet explorer but when it comes to our production site (intranet) it doesn't like it. Is it possible something on the server is blocking something? I can't tell. In my webconfig I denied all the possible sequences that are blocked by the servers (as shown below) <denyQueryStringSequences> <remove sequence=";"/> <remove sequence="--"/> <remove sequence="%3C"/> <remove sequence="%3E"/> <remove sequence="'"/> <remove sequence="&quot;"/> <remove sequence="`"/> <remove sequence="//"/> <remove sequence="/*"/> <remove sequence="*/"/> <remove sequence="declare"/> <remove sequence="varchar"/> <remove sequence="nchar"/> <remove sequence="exec"/> <remove sequence="update"/> <remove sequence="delete"/> <remove sequence="insert"/> <remove sequence="cast"/> <remove sequence="script"/> <remove sequence="0x"/> <remove sequence="\n"/> <remove sequence="\r"/> <remove sequence="char("/> <remove sequence=";alter"/> </denyQueryStringSequences> I also tested the production site on Firefox and it works just not internet explorer. What could be causing the problem that it wouldn't let it run properly on internet explorer? Debug page: http://debug.datatables.net/ogejiz Live Example: http://live.datatables.net/dihotiba/1/

hi, I'm using https://cdn.datatables.net/1.10.9/js/jquery-1.11.3.min.js and https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js files in my code with tag and css file with tag. But its not showing sorting/paging/search box on my grid. Its only displaying data in table.

to the combinations of searches, or, when done correctly,

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?

Hello, i'm using datatables as below: .js: var oatable = $("#DataTable").dataTable( { "bProcessing": true, "bServerSide": true, "bAutoWidth": false, "destroy": true, "iDisplayStart":"0", "iDisplayLength": "10", "scrollY": "700px", "scrollCollapse": true, "sAjaxDataProp": "aaData", "oLanguage": { "sSearch": "Filter: " }, "sAjaxSource": "./sendData", "sPaginationType": "full_numbers", "fnServerParams": function ( aoData ) { aoData.push( { "name": "name", value: name }); }, "fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) { if ((String)(aData["Action"])=="true") { $(nRow).css('color', 'grey').css('font-style', 'italic').css('font-size','14px;'); }else{ $(nRow).css('color', 'black').css('font-size','14px;'); } }, "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) { oSettings.jqXHR = $.ajax( { "dataType": "json", "type": "GET", "url": sSource, "data": aoData, "success": function(data){ fnCallback(data); } }); }, "aoColumns": [ { "mData": "custId"}, { "mData": "Id", "sWidth":"6%"}, { "mData": "name" }, { "mData": "Date", "sWidth":"10%"}, ] }); I have set all these variables in the server-side: iTotalRecords; iTotalDisplayRecords; sEcho; sColumns; aaData; I am able to see all the data load onto the table at once,like hundreds at once, but there is no pagination although i can see the right pagination numbers on the left bottom right, I can also see ("1 to 10 out of 200 entries" at the bottom left which is correct). I am also not able to sort or do a global sSearch or paginate. what am i missing? Any help would be highly appreciated!!

i am have used datatable 1.10.7 vers used in java struts

rows that have the searched for value and returns

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 saw a posting in the comments, but for me it did not work (http://www.datatables.net/examples/api/multi_filter.html). Someone answering me a question? The it was made I have sent several requests to my server. It is possible to only send a request with all que any fields are filled? I Was Unable to it in Place. I'm using version 1.10.