Filter by Dropdowns

jimp

I have a site I have inherited that is using dataTables 1.8. In this application, there are some select boxes that are currently not populated with any data.

Using the information from this page (http://www.datatables.net/examples/api/multi_filter_select.html) I have started the process of putting valid data into the dropdowns. In fact, it basically works. Except that it doesn't do quite what I expected it to do. I ran the debug tool, you can find the results here (http://debug.datatables.net/uqojeq).

There are a couple of issues so far.

First, the very first dropdown box doesn't ever get propagated with any information. There is data in the first column, which should appear in the dropdown. I don't actually know why this occurs, and I can't seem to find any rhyme or reason for it.

Second, the dropdowns only contain information listed on the very first page load. If I use the pagination to switch pages, it stays the same, even if there is different data present. Additionally, it only lists a small portion (those on the first page) of the data, instead of all keys in the column.

Finally, it sometimes randomly does not load anything into the data table. I believe this may be a server issue, but I thought I'd post it here in case other people are having similar issues.

If anyone could shed some light on what's going on and how to go about fixing this, that would be most appreciated.

Thanks!

jimp

I couldn't get that script to automagically create full select option lists of my column data. I ended up just writing a small script to generate it on the server before serving the web page and then hooking an oTable.fnFilter() function to the onChange event handler for the different selects.