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..

Hi, I have a table which includes a jquery link in column one. When we export the data, column one includes Javascript code. I tried to create the action function to remove the code but had no luck. OUTPUT from export: App Name Salsa ID App Status Critical Notifications App Level Score Target Stretch Target "application1 jQuery(document).ready(function () { var options_anchor_599436381 = {}; options_anchor_599436381.jqueryaction = anchor""; options_anchor_599436381.id = ""anchor_599436381""; options_anchor_599436381.targets = ""appSummary""; options_anchor_599436381.href = ""/nfmi/applicationSummaryView.action""; options_anchor_599436381.hrefparameter = ""applicationModel.appListIndex=12""; jQuery.struts2_jquery.bind(jQuery('#anchor_599436381')" options_anchor_599436381); });" APP0 Full Y 28 4 81% 90% 95% Datatable code: $("#appsummary").DataTable( { dom : "<'row'<'col-md-3'l><'col-md-4'f><'col-md-3'><'col-md-2'B>>t<'row'<'col-md-6'i><'col-md-6'p>>", lengthMenu : [ [ 10, 25, 50, -1 ], [ 10, 25, 50, "All" ] ], buttons : [ { extend : 'copyFlash', text : 'Copy current page', action : function ( sVal, iColumn, nTr, iDataIndex ) { if (iColumn === 0) { var str = sVal var end = str.indexOf("jQuery")-1; return sVal.substring(0, end); } return sVal; }} ]}); any help would be much appreciated. Thanks, Jim

I want to implement if (fileType != X), then only display record else move to another. Following code is already working in present solution and i am bound to update it only. columnDefs: [ {"width": "30%", targets: 0}, {"width": "30%", targets: 1}, {"width": "30%", targets: 2} ], columns: [ {"data": "fileType"}, {"data": "fileName"}, {"data": "fileDate"} ], aoColumnDefs: [ { "aTargets": [ 1 ], "mData": "fileName", "mRender": function ( data, type, full ) { return '<a href="'+full.link+'">'+full.fileName+'</a>'; } }] The functionality is that after Ajax calls, JSON data is received and gets populated using datatables. How can i implement if (fileType != X) in above snippet? Thanks in advance. Sorry tried to format question but unable too.

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.