Search

Can we have 2 or more search forms, with each form filtering on a different column ?

I have the following fiddle example that I am trying to get working with a database. The fiddle has 2 rows for test data and the search and column search works. Now with my example connecting to the database has 2 files an index.php file and a employee-grid-data3.php file. index.php looks very similar to the fiddle, but it has the following code, and the tbody/rows will be filled by data returned from the db <script type="text/javascript" language="javascript" > $(document).ready(function() { var dataTable = $('#employee-grid').DataTable( { "processing": true, "serverSide": true, "ajax":{ url :"employee-grid-data3.php", // json datasource type: "post", // method , by default get error: function(){ // error handling $(".employee-grid-error").html(""); $("#employee-grid").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server -- startagain1-index3.php </th></tr></tbody>'); $("#employee-grid_processing").css("display","none"); } } } ); } ); </script> my index.php file points at employee-grid-data3.php which looks like this here with the relevant details filled in. If i check this in the browser, I can see the data that is returned looks like: {"sEcho":0, "iTotalRecords":"999", "iTotalDisplayRecords":"999", "aaData":[["2015-10-06","427","60","137765","Samsung Korea","Samsung SM-G900I","$39 Plan"], ["2015-10-06","592","620","0","Apple Inc","Apple iPhone 6 (A1586)","PREPAY STD - TRIAL - #16"], ... **Now the end result is all the data is returned and displayed on one page. Which means that the pagination, search adn column search is not working. What do I have to do for my datatables to accept the data returned in this format? ** As an aside I have another employee-grid-data.php file that returns data like this and the search and pagination works. {"draw":1, "recordsTotal":999, "recordsFiltered":999, "data":[ ["2015-10-06","717","290","16019540","Apple Inc","Apple iPhone 5S (A1530)","$29 Plan"], ... Can anyone advise where I am going wrong?

I use the sample "Individual column searching (select inputs)". https://datatables.net/examples/api/multi_filter_select.html When i choose 37 value for colomn "Age" I have three displayed rows. In Office column I have "Sidney, Tokyo and London". I want to rebuild the select element of "Office" with this three values. Thanks!

Hi there, As I click the button one of the tables 're'draws but the other one doesn't. What I'm trying to achieve is one table filtered by the date and the other one to be filtered by the results of the other table. Here is some code: http://pastebin.com/QeezvXmY

If it contains 3000+ records taking too much time to load.Please help to fix this issue asap

I am trying to show my entities via js datatables. Altough i set iDisplayLength as 10 it shows all the rows! You can see js and html codes over stackoverflow. http://stackoverflow.com/questions/36344226/jquery-datatables-doesnt-filter-rows-by-displaylength

Is there a possibility to add a dropdown-box above a column and when you choose something from a list of options the list gets filtered on that keyword in that column?

When I have 14 records after column filtered with select option and I am in page 2 (11-14 records page) when I refresh the page the filtered select column state only saved. It remain shows 1 st page with my select filter(1-10 records page). I want to make both in my page simulataneously. Suggest me some ideas and kindly help me to solve this issue

I have a data table with 11 columns, and the search box does not work with fields in every single column. For example, say I have | Col | col2 | col3 | |-----|------|------| | a1 | b1 | c1 | | a2 | b2 | c2 | | a3 | b3 | c3 | I type "a1" in the search box and that gives me the row with [a1, b1, c1], which is expected. However, if I typed "c1" instead, nothing comes up. In other words, it seems like searching on col3 is completely broken. What makes this interesting is that this behavior is inconsistent across different browsers. For example, searching col3 would be broken in chrome but would work in firefox. Similarly, searching col2 would work on chrome but not in firefox. Can anyone shed some light to this issue? Here is how I am initializing the datatable: $('#myTable').DataTable({ scrollY: this._calculateHeight() });

.columnFilter({ sPlaceHolder: "head:before", aoColumns: [ { type: "date" }, { type: "text" }, { type: "select" } ]