Search

I'm creating Datatable column header dynamically. However, I need two header rows in the table. First header row needs to display "Information" spanning 2 columns and second header row is as below. Is it possible to achive this? var tableHeaderJson = {"columns": [{"title": "Host Group"}, {"title": "Flavor"}]}

Not working for me plz help

I have a lot of checkbox grouped. For example group cities depends on cities table from db, streets depends on street and so . For example the cities group code: <div class="form-group"> <div class="button-group"> <button type="button" class="btn btn-default btn-sm btn-block dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> Streets <span class="caret pull-right"></span> </button> <ul class="dropdown-menu"> @foreach($streets as $street) <li> <input type="checkbox" class="minimal" id="area-{{ $street->slug }}"> <label for="area-{{ $street->slug }}">{{ $street->name }}</label> </li> @endforeach </ul> </div> </div> And the result: https://i.imgur.com/C2vGt02.png So how can I collect all the filters and join the tables in backend to return the proper results? Also some of the filters are not in the table because the table would be too long. Thank you.

I was planning to implement bootstrap popover for DataTables but it is not working as it should be. Sometimes I see popovers on page 1 and not on others. It is not consistent. If I use ajax.load function it is not at all working. Code below: { "bSortable": false, "data": "empId", "render" : function(data,type, full, meta) { //Popover $('.hoverclass').popover().hover(function(e) { e.preventDefault(); }); //estimateId = data; return ''; } Help is appreciated, thanks :)

please sggesst

So right now I have this code snippet that fires the search when more than 3 characters are pressed: $(".filter").on("keyup change", function () { //clear global search values if(this.value.length >= 3) { // Call the API search function vendorListTable.search(""); vendorListTable.column($(this).data('columnIndex')).search(this.value).draw(); } // Ensure we clear the search if they backspace far enough if(this.value == "") { vendorListTable.search(""); vendorListTable.search("").draw(); } }); However, when I clear the field either by pressing backspace or cutting the value datatables won't reload. Any ideas as to how this is achieved?

Hi, I want to use dataTables w/out AJAX.I do it.Unfortunately i have product groups with about 3000 records.The page loads about 5 seconds which is bad.My questions is - is there any way to load only the data for the selected page in order to not load slow.If we click on 4page, to reload the entire page with the content for 4.

$(function () { $("#example1").DataTable(); $('#example2').DataTable({ "paging": true, "lengthChange": true, "searching": true, "ordering": true, "info": true, "autoWidth": false }); });

Hi, I am doing 2 datatables in one page, separated. In first table I have contract directions of one client. And in second table I have the equipment included in the contract. When I select one direction in first table the second table reloads and shows only the equipment of this direction, but I cant do this. The request goes, but parametres not, and returns null array. Any suggestion?? Anyone does it?? Thanks

I'm using code igniter for my datatables. if using print on menu tabletoools, datatables can export all row but on csv or excel only page 1. why ? thanks. This my controler : public function tabel_log() { $aColumns = array('tanggal', 'nama', 'ip','type','gadget'); $sTable = 'log'; $iDisplayStart = $this->input->get_post('iDisplayStart', true); $iDisplayLength = $this->input->get_post('iDisplayLength', true); $iSortCol_0 = $this->input->get_post('iSortCol_0', true); $iSortingCols = $this->input->get_post('iSortingCols', true); $sSearch = $this->input->get_post('sSearch', true); $sEcho = $this->input->get_post('sEcho', true); // Paging if(isset($iDisplayStart) && $iDisplayLength != '-1') { $this->db->limit($this->db->escape_str($iDisplayLength), $this->db->escape_str($iDisplayStart)); } // Ordering if(isset($iSortCol_0)) { for($i=0; $i<intval($iSortingCols); $i++) { $iSortCol = $this->input->get_post('iSortCol_'.$i, true); $bSortable = $this->input->get_post('bSortable_'.intval($iSortCol), true); $sSortDir = $this->input->get_post('sSortDir_'.$i, true); if($bSortable == 'true') { $this->db->order_by($aColumns[intval($this->db->escape_str($iSortCol))], $this->db->escape_str($sSortDir)); } } } if(isset($sSearch) && !empty($sSearch)) { for($i=0; $i<count($aColumns); $i++) { $bSearchable = $this->input->get_post('bSearchable_'.$i, true); // Individual column filtering if(isset($bSearchable) && $bSearchable == 'true') { $this->db->or_like($aColumns[$i], $this->db->escape_like_str($sSearch)); } } } // Select Data $this->db->select('SQL_CALC_FOUND_ROWS '.str_replace(' , ', ' ', implode(', ', $aColumns)), false); $rResult = $this->db->get($sTable); // Data set length after filtering $this->db->select('FOUND_ROWS() AS found_rows'); $iFilteredTotal = $this->db->get()->row()->found_rows; // Total data set length $iTotal = $this->db->count_all($sTable); // Output $output = array( 'sEcho' => intval($sEcho), 'iTotalRecords' => $iTotal, 'iTotalDisplayRecords' => $iFilteredTotal, 'aaData' => array() ); foreach($rResult->result_array() as $aRow) { $row = array(); foreach($aColumns as $col) { $row[] = $aRow[$col]; } $output['aaData'][] = $row; } echo json_encode($output); } This my View : var datatables = $('#table_log').dataTable( { "bJQueryUI": true, "bProcessing": true, "bServerSide": true, "bDeferRender": true, "sServerMethod": "GET", "sPaginationType": "full_numbers", "order": [[ 0, "desc" ]], "iDisplayLength" : 8, "sAjaxSource": "index.php/con_datatables/tabel_log", "aoColumns": [ { "title": "Tanggal","sWidth": "25%","aadata": "tanggal" }, { "title": "Nama","sWidth": "15%","type": "natural","aadata": "nama" }, { "title": "IP","sWidth": "20%","aadata": "ip" }, { "title": "Type","sWidth": "20%","aadata": "type" }, { "title": "Use","sWidth": "20%","aadata": "gadget" } ], "sDom": '<"H"Tlfr>t<"F"ip>', "oTableTools": { "sRowSelect": "os", "sSwfPath": "/js/copy_csv_xls_pdf.swf", "aButtons": [ { "sExtends": "copy", "oSelectorOpts": { filter: 'applied', order: 'current' } }, { "sExtends": "csv", "oSelectorOpts": { filter: 'applied', order: 'current' }, "sFileName": ".csv" }, { "sExtends": "xls", "oSelectorOpts": { filter: 'applied', order: 'current' }, "sFileName": ".xls" }, { "sExtends": "pdf", "oSelectorOpts": { filter: 'applied', order: 'current' }, "sFileName": "*.pdf" }, { "sExtends": "print", "oSelectorOpts": { filter: 'applied', order: 'current' } } ] } } );