Search

I have columns on a datatable that are from a product table and other columns from an attribute_values table. The attributes table is related to the attribute_values table via the foreign key attribute_id. The attributes table which hold the name of each unique attribute. The attributes table is flexible, allowing a variable number of attributes to be stored from a variety of different other models using attributable_id and attributable_type fields. How do I make these fields searchable over AJAX using DT with yajra/laravel-datatables? For instance, I might have attributable_id=1 AND attributable_type='Product' AND attribute_id=5.

I am using jquery.dataTables but i am not able to how to use it can any one post it with code or example.

Hi Everybody, after changing the datatable to work with server side processing the input text box stop working there's not mention that the input text box not working in server side mode. how can i get it to work? thank you

ajax data source code $(document).ready(function() { $('#example').DataTable( { "ajax": "data/objects.txt", "columns": [ { "data": "name" }, { "data": "position" }, { "data": "office" }, { "data": "extn" }, { "data": "start_date" }, { "data": "salary" } ] } ); } );

table header nd table content was mismatching $('#ProjTB').DataTable({ "scrollX": true, "ordering": false, "info":false, //"scrollCollapse": true, "pageLength": 4, "responsive": true, initComplete: function () { this.api().columns().every(function () { var column = this; var select = $('<select><option value=""></option></select>') .appendTo($(column.header()).empty()) .on('change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); column .search(val ? '^' + val + '$' : '', true, false) .draw(); }); column.data().unique().sort().each(function (d, j) { select.append('<option value="' + d + '">' + d + '</option>') }); }); } }); </script>

I managed to add the icon and button by doing it this way: "dom": '<"top"f>', "oLanguage": { "sSearch": '<a class="btn searchBtn" id="searchBtn"><i class="fa fa-search"></i></a>' }, But it's not attached to the box with a similar border, if that makes sense. I want it to attach similar to how span does it in the HTML. I have tried finding the answer online but no luck so far.

Hello, I don't understand DataTables, I just want to draw() the lines that have a specific class. But I can't find the answer anywhere. I work with jQuery var $datatable = $("#data-table-modal").DataTable(); var rows = $("#data-table-modal").find("tr.ligne-9"); $datatable.search(rows, true, false).draw(); // Doesn't work Please help!!!!

Hello Guys I am using server side DataTable and its getting records and working with the pagination also but when i am searching or sorting any column then its requesting to current Page ADDRESS URL not on AJAX URL which i had given in DataTable configuration. My DataTable configuration JS code is var csrfToken = $("meta[name='csrf-token']").attr("content"); var oTable = $("#tableClientData").dataTable({ "processing": true, "serverSide": true, "ajax": { url: siteurl + "/clientdata/activities", type: "POST", data: function(d){ d._token = csrfToken; } }, "sPaginationType": "bootstrap", "sDom": "t<'row'<'col-xs-6 col-left'i><'col-xs-6 col-right'p>>", "bStateSave": false, "iDisplayLength": 8, "aoColumns": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, {"bSortable": false} ] }); oTable.columnFilter({ "sPlaceHolder": "head:after", "aoColumns": [ {type: "text", ajax: ''}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, {type: "text"}, null ] }); Please help me. Thanks

I've link both .js file and .css file in my code as below, it shows the grid with my data but its not showing pagination/filter/sorting..

I have intranet page that seems to not want to work properly on internet explorer. I used my render code on the live.datatables page and it works correctly even on internet explorer but when it comes to our production site (intranet) it doesn't like it. Is it possible something on the server is blocking something? I can't tell. In my webconfig I denied all the possible sequences that are blocked by the servers (as shown below) <denyQueryStringSequences> <remove sequence=";"/> <remove sequence="--"/> <remove sequence="%3C"/> <remove sequence="%3E"/> <remove sequence="'"/> <remove sequence="&quot;"/> <remove sequence="`"/> <remove sequence="//"/> <remove sequence="/*"/> <remove sequence="*/"/> <remove sequence="declare"/> <remove sequence="varchar"/> <remove sequence="nchar"/> <remove sequence="exec"/> <remove sequence="update"/> <remove sequence="delete"/> <remove sequence="insert"/> <remove sequence="cast"/> <remove sequence="script"/> <remove sequence="0x"/> <remove sequence="\n"/> <remove sequence="\r"/> <remove sequence="char("/> <remove sequence=";alter"/> </denyQueryStringSequences> I also tested the production site on Firefox and it works just not internet explorer. What could be causing the problem that it wouldn't let it run properly on internet explorer? Debug page: http://debug.datatables.net/ogejiz Live Example: http://live.datatables.net/dihotiba/1/