Search
11455 results 2131-2140
Forum
- 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
- 11th Mar 2015How to disable future date in date column filter{% 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>
- 19th Feb 2015column filter based on the field values that has colour.table that uses column filtering as per https://datatables.net/release-datatables/examples/api/multi_filter_select.html Some
- 4th Dec 2014DataTable Column Filter Not WorkingI 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