Search
43637 results 7121-7130
Forum
- 2nd May 2017Issue with fixed table headerHi, I'm using the TablePress plugin on a WordPress site, and the plugin author's shortcode for the fixed header is not working. He looked into the issue, couldn't solve it, and suggested I ask at this forum because his plugin uses the DataTable JS library. Here is a link to our discussion of the issue. I ran your debugger and here is the result I received: "[Violation] Forced reflow while executing JavaScript took 81ms." The web page having this issue with the fixed header is http://mf2.openairwebdesign.com/music-sitting-together-songbook/. Very much appreciate any help you can offer. Thanks, Suzanne
- 25th Apr 2017DataTables-Find data in a table, but do not filter on the server sideI want to load the data on the server side (server side) but when looking for any content I do not want to be server side with sql queries for example: Quiero cargar los datos del lado del servidor (server side) pero a la hora de buscar cualquier contenido no quiero que se haga del lado del servidor con consultas sql por ejemplo: if( !empty($params['search']['value']) ) { $where .=" WHERE ( nombre LIKE '%".$params['search']['value']."%' )"; $where .=" OR employee_salary LIKE '".$params['search']['value']."%' "; $where .=" OR employee_age LIKE '".$params['search']['value']."%' )"; } Is there any way to do this?
- 19th Apr 2017how to find a unique rows for each column in the table .here is my code :smile: this.x.then(df => { let rowsData = this.table.column(0).data().unique(); $("#Addfilters").click(function() { console.log(rowsData); }); }); but this is giving me a error : a.slice is not a function . thanks in advance
- 14th Apr 2017Can not sort column bcoz of using joins on two table and i am using server side processing c#select @i:=@i+1 AS RowNum,A.ReceiptNo as ReceiptNo,DATE_FORMAT(A.ReceiptDate,'%d-%m-%y') as ReceiptDate,G.Name as Guest,R.Name as Room,A.Amount from advancereceipt A LEFT JOIN guestmaster G ON A.Guest = G.Code LEFT JOIN roommaster R ON A.Room = R.Code, (SELECT @i:=0) AS foo where (Search IS NULL Or A.ReceiptNo like CONCAT('%' , Search , '%') Or DATE_FORMAT(A.ReceiptDate,'%d-%m-%y') like CONCAT('%' , Search , '%') Or G.Name like CONCAT('%' , Search , '%') Or R.Name like CONCAT('%' , Search , '%') Or A.Amount like CONCAT('%' , Search , '%')) order by case when SortDir <> 'ASC' then '' when SortCol = '1' then A.ReceiptNo end ASC, case when SortDir <> 'DESC' then '' when SortCol = '1' then A.ReceiptNo end DESC, case when SortDir <> 'ASC' then '' when SortCol = '2' then A.ReceiptDate end ASC, case when SortDir <> 'DESC' then '' when SortCol = '2' then A.ReceiptDate end DESC, case when SortDir <> 'ASC' then '' when SortCol = '3' then G.Name end ASC, case when SortDir <> 'DESC' then '' when SortCol = '3' then G.Name end DESC, case when SortDir <> 'ASC' then '' when SortCol = '4' then R.Name end ASC, case when SortDir <> 'DESC' then '' when SortCol = '4' then R.Name end DESC , case when SortDir <> 'ASC' then 0 when SortCol = '5' then A.Amount end ASC, case when SortDir <> 'DESC' then 0 when SortCol = '5' then A.Amount end DESC );
- 10th Apr 2017Custom Horizontal table layout with column headings in each row?Hey, Attempting to create what is typically a simple layout but using DataTables is proving a little troublesome. I must be missing something as a newcomer to the DataTables community. I have attached a mock-up example of what i am trying to achieve with DataTables. Any pointers / solutions in the right direction appreciated. Thanks in advance.
- 7th Apr 2017on resize bootstrap data table header rows only collapses the first row th how can I fix this?Hello, I have a problem with the responsive of datatable module. I added an extra tr in the thead section under the header and added an individual column search row however when resizing the first row collapses fine but the second row with the search inputs is not collapsing with the data. how can I fix this Thank
- 31st Mar 2017How search and column sorting work for dynamic data from data table ?how top up right side display search box work for dynamic data and sorting column for dynamic data ?
- 21st Mar 2017How can i pass input data from JSP to data table and receive on Controller?Hi, i am letting user enter some data in text field, and on button press,i am calling below JQuery function and making Ajax call inside. Below is my JQuery Function and Input field details. $("#SearchByVIN").click(function() { $("#error").hide(); var formData = $('#vinSerach').serialize(); $.ajax({ type: "POST", url: "ErrorVin", data: formData, crossDomain: false, async : true, success: function(response) { if(response){ $("#error").show(); $("#error").html(response); $(window).scrollTop($('#error').offset().top); }else{ $("#searchResult").show(); $("#searchResult_info").show(); $("#searchResult_paginate").show(); var oTable = $('#searchResult').dataTable( { "bDestroy": true, "iDisplayLength": 2, "bFilter": false, "bFilter": false, "bLengthChange": false, "sAjaxSource": "SearchByVIN", "aoColumns": [ { "mData": "gdId" }, { "mData": "agency" }, { "mData": "documentType" }, { "mData": "countyName" }, { "mData": "organizationName" } ] } ); } }, error: function(result){ alert(result); } }); }); Search By VIN Note that, first i am calling url: "ErrorVin", method in controller. In which, i am properly recieving data in controller using Form Bean. But when it comes in else, i am using "sAjaxSource": "SearchByVIN", but in this case, i am not revieving any jsp input values in controller method mapped with this url. So, if i want to pass input values in this second call, how can i achieve that?
- 21st Mar 2017destroy table takes long time/freezes webpageTurns out.... it was $('#tableBody').html(rows) that actually froze it. :# I'm trying to find ways to solve this problem now... :s
- 6th Mar 2017Can I set the page info of a table?It's like this. Now, I request to my server in my own function without setting the ajax. And in my server, I have pagination already.That is to say,the response from server only contains records in one page. So I want to tell datatables the total number, current page and some other infomation of my table.I know I can use the api page.info() to get the info of the pagination, but how can I set the info?