Search

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

{% block content %} View Ticket {% load staticfiles %} $(document).ready(function(){ $('#myTable').dataTable({ "order": [[ 5, "desc" ]] }); $('#myTable').dataTable().yadcf([ {column_number : 2, data: ['Minor', 'Major', 'Critical'], filter_default_label: "Select"}, {column_number : 3, data: ['New', 'Assigned', 'ReAssigned','Resolved'], filter_default_label:"Select",filter_match_mode:"exact"}, {column_number : 5, filter_type: "range_date",date_format:"yyyy/mm/dd"} ]); }); {% csrf_token %} View Ticket Ticket Subject Priority Status Assigned To Created Date Update {% for u in obj %} {% if u.Priority == "Major" %} {{ u.Ticketid }} {{ u.Subject }} {{u.Priority }} {{ u.Status }} {{ u.AssigneeName }} {{ u.CreatedDate|date:"Y/m/d H:i:s"}} <ahref="/HomePage/ticketdetails/{{u.Ticketid}}">View/Update {% elif u.Priority == "Minor" %} {{ u.Ticketid }} {{ u.Subject }} {{ u.Priority }} {{ u.Status }} {{ u.AssigneeName }} {{ u.CreatedDate|date:"Y/m/d H:i:s"}} <ahref="/HomePage/ticketdetails/{{u.Ticketid}}">View/Update {% elif u.Priority == "Critical" %} {{ u.Ticketid }} {{ u.Subject }} {{u.Priority }} {{ u.Status }} {{ u.AssigneeName }} {{ u.CreatedDate|date:"Y/m/d H:i:s" }} <ahref="/HomePage/ticketdetails/{{u.Ticketid}}">View/Update {% endif %} {% endfor %} </footer> </body>

table that uses column filtering as per https://datatables.net/release-datatables/examples/api/multi_filter_select.html Some

I am using backbone and jquery datatable.I am loading data from server side .Every thing is working fine except column filter.I am not getting any error also. self.oTable = $('#example').dataTable({ "bDestroy": true, "sScrollX": "965px", "bProcessing": true, "bServerSide": true, "bPaginate": true, "bLengthChange": false, "bFilter": false, "bInfo": true, "sDom": 'Rlfrtip', fnDrawCallback: function( oSettings ) { alert( 'DataTables has redrawn the table' ); }, "aoColumns": columns, "aoColumnDefs": [ { "sClass": "dpass", "aTargets": [ 0 ] } ], }).columnFilter() this.oTable.fnBuildCustomeHead(); setTimeout(function() { var foot = $("#example").find('tfoot'); if (!foot.length) foot = $('<tfoot id="tfoot">').prependTo("#example"); $('#example thead tr ').each(function (id,text) { $('#example thead').append(text); }); $('#example tfoot').append("<tr></tr>"); $('#example thead tr th').each(function (id,text) { if(id!==0) $('#example tfoot tr').append("<th>"+text.getAttribute('aria-label').split(':')[0]+"</th>"); }); }, 5000); Below is my html code <table cellpadding="0" cellspacing="0" border="0" id="example"> </table> Please help Thanks