Search

I 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?

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

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.