Search

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 );

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.

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

how top up right side display search box work for dynamic data and sorting column for dynamic data ?

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?

Turns out.... it was $('#tableBody').html(rows) that actually froze it. :# I'm trying to find ways to solve this problem now... :s

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?

Hello, I use DataTable and Bootstrap (with adminlte) and I would like to draw a green triangle in the upper right corner of some cells. How can I do it ? I'm filling the DataTable with ajax call (MySql) and the content of the cell is now only text (stored in the PHP variable $row['thiscolumn']). Many thanks for your help... T.

help me ; i want to show records only logged user delails , how to display

In this example https://jsfiddle.net/4aLmbgwg/8/ there are two examples, it's the same structure repeated twice, a datatables tale with scrollY put into a boostrap "collapse" panel. each has its button to hide/show, but the first is generated already in the "open" state while the second is generated "closed" but the first behaves well even closing and reopening it, while the second, after "opening" has headers completely wrong... apart that, also columns widths seem to work well only in the first... anyway they are different in both cases... Can anyone shade some light, explain how to fix this? Thanks, Marco