Search

14187 results 3221-3230

Forum

14th Feb 2017Sort, pagination and search functionality not working when I pull data from DB | Python | Django1.9
All of the features work when the Data is Raw HTML but the moment I use a For loop to extract data from the DB using Models the table is population perfectly but the above said features do not appear. Below is my Code: <head> <link rel = "stylesheet" href="http://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script> <script src="http://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script> <script> $(document).ready(function(){ $('#example').DataTable(); }); </script> <meta charset="UTF-8"> <title>Test</title> </head> <table id="example" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>Name</th> <th>Position</th> <th>Office</th> <th>Age</th> <th>Start date</th> </tr> </thead> <tbody> {% for obj in object_list %} <tr> <td> {{obj.title}} </td> <td> {{obj.title}} </td> <td> {{obj.title}} </td> </tr> {% endfor %} </tbody> </table> </body> </html>
2nd Feb 2017Search for all rows having an empty cell
Hi there, i'm struggling to find a solution with latest version of DT. I've a large table with rows that might contain empty values. When these cellsare empty, they already have a css class applied on (<td class="empty">) , as well as the row (<tr class="hasEmpty">). These empty cells can be in any column (except the first which always contains a value - not sure if relevant) Then i'd like to have a button outside the table to show all rows that contain at least one cell which is empty. Is there a way do to this? Based on the empty value as a regExp ? ( '^$' ) Or maybe the class which is already applied ? myTable.columns().search('^$').draw() will return no result. (nor myTable.columns().search('something').draw() , although there is "something" in some cells, not sure why...) Thanks for your help !
27th Jan 2017datatables search inside csv regex
can anyone help me on this stackoverflow question :- https://stackoverflow.com/questions/41425765/datatables-search-inside-csv-regex
11th Jan 2017how jquery jtable search ,filter and curd oprations all in one table in java mvc
plz give the entair code for full length code
21st Nov 2016How can I load a DataTable from JQuery when Search is implemented
Hi Friends, I am developing an application in MVC ASP.Net. I have used Datatables inmy application. I have used model binding for the datatable as follows Script for Datatable $('#tblReports').DataTable({ paging: true, lengthChange: false, searching: false, ordering: true, info: true, autoWidth: true, scrollX: true, dom: 'Bfrtip', buttons: [ 'excel' ] }); HTML table Employee Name Leave Type From Date To Date No of Days Is Half Day Leave Description Status Approved By Approved Date Rejected By Rejected Date Supervisor Comments foreach (var leaveDetail in Model) { if (leaveDetail.LeaveStatusName != "Save" & leaveDetail.LeaveStatusName != "Cancel") { leaveDetail.EmployeeName leaveDetail.LeaveTypeName leaveDetail.FromDate.ToShortDateString() leaveDetail.ToDate.ToShortDateString() if (leaveDetail.HalfDay != null) { if (leaveDetail.ToDate.ToShortDateString() == leaveDetail.FromDate.ToShortDateString()) { ("1"); } else { ((leaveDetail.ToDate - leaveDetail.FromDate).TotalDays); } } else { ("0"); } leaveDetail.HalfDay leaveDetail.EmployeeComments leaveDetail.LeaveStatusName leaveDetail.ApprovedBy leaveDetail.ApprovedDate leaveDetail.RejectedBy leaveDetail.RejectedDate leaveDetail.SupervisorComments } } Now I need to load only the Datatable with out refreshing the page. I am loading the all the views in one master view. Could you help me.
10th Nov 2016Dom element not aligned with search field
Hi, I would like to add refresh button to my datatable but I have a problem with the position of the button. I have tried with Custom toolbar elements and with Buttons extension and I have the same problem. This is part of my code acquisitionTable = $('#acquisitionsTable').DataTable({ responsive: true, "bLengthChange": false, deferRender: true, scrollY: '70vh', scrollCollapse: true, scroller: true, dom: 'Bfrtip', buttons: [ { text: 'Refresh<i class="fa fa-refresh"></i>', action: function ( e, dt, node, config ) { alert( 'Button activated' ); } } ], I have attached the image. In browser debug I see: <div class="dt-buttons"> <a class="dt-button" tabindex="0" aria-controls="acquisitionsTable" href="#"> <span>Refresh<i class="fa fa-refresh"></i></span> </a> </div> <div id="acquisitionsTable_filter" class="dataTables_filter"> <label>Search:<input type="search" class="form-control input-sm" placeholder="" aria-controls="acquisitionsTable"> Do you know what is wrong? The buttons css exist but it doesnt load for the specific element.Thanks
8th Nov 2016how can we insert index column(serial no's) and how to apply sorting and search functionality to it
1 Tiger Nixon System Architect Edinburgh 61 $320,800 2 Garrett Winters Accountant Tokyo 63 $170,750 3 Ashton Cox Junior Technical Author San Francisco 66 $86,000 4 Cedric Kelly Senior Javascript Developer Edinburgh 22 $433,060 5 Airi Satou Accountant Tokyo 33 $162,700 6 Brielle Williamson Integration Specialist New York 61 $372,000
26th Sep 2016Datatabes hide/show column based on checkbox(es) event as in Search box filter
I am using data tables to display a table with more than 5000 records along with that i will have to hide/show rows based on checkbox inputs. ex. I have 3 checkboxes named "A, B and C". When I click 'A' i have to display only records that contains 'Aaaa' in a particular column data of that row. When I loop through the table and hide/show it takes lot of time to render and sometimes the script breaks. Any suggestions and help would be great.
1st Jul 2016Why search box not fetch data in the table
plz help me..
13th Jun 2016SharePoint - search box, filter and navigation not working
I've linked both .js file and .css file in my code as below ,but it shows the grid with my data but its not showing pagination/filter/sorting.. Am using a visual webpart and below is my code for ascx file <script type="text/javascript"> $(document).ready(function () { $('#GridView1').dataTable({ "sPaginationType": "full_numbers", "aaSorting": [], "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]], "pageLength": 14, //"scrollY": "200px", //"scrollCollapse": true, "sDom": 'T<"clear">lfrtip', "tableTools": { "sSwfPath": "http://www.datatables.net/release-datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf" }, /* Disable initial sort */ "bDestroy": true, "bProcessing": true, "bpaging": false, "bSort": false }); }); </script> Please help