Search

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" } ]

Hi, i'm a newbie of datatables ;) I'm trying and learning how to use this powerful tool. I have to render a simple table with 2 columns: Name, Salary. On the db table i have 3 columns: Name, Salary, Year and i'm using ajax to request/response the data. What i want to do is put a select in the toolbar to use for insert a custom parameter in the ajax call. I looked that is can be achieved by using data and dataSrc option in the ajax call. In the response i insert a json parameter: "YearFilter" example: "YearFilter": {0:[2013] 1:[2014, selected]} But how can i drow a custom toolbar inserting only a centered select for the year ad populate it with the parameter "YearFilter" contained in the ajax response ? Thanks.

Hi, I need to debounce ( or throttle as alternative ) on the the individual column search input. I use DT v.1.10 so I can't use fnSetFilteringDelay plug-in, and I'm still confused on the searchDelay. Cound you give some basic example? Thanks