Search

solved

Allan, I ended up just positioning the datatable WAY out of the viewport. I'm going to revisit this as part of the infinite amount of technical debt that we accumulate through projects. :D Will post up a gist or jsfiddle with errors, sample markup and js to replicate the issue. In the meantime, here is the error I was receiving when the container that holds the table that is referenced to instantiate the datatable: Uncaught TypeError: Cannot read property 'oFeatures' of null It throws that when i call fnFilter on aforementioned datatable. Like I said, I'll come back to this to discuss a real solution for this (not just hiding it via absolute positioning). Thanks for your time Allan, you're posts and plugins have been most helpful here.

Sounds like you might find this plug-in quite useful: http://datatables.net/plug-ins/api#fnSetFilteringDelay . Also make sure you are using sEcho in your server-side response as that is there specifically to stop out of sequence errors. Allan

My question is, how should I change my links so that the drop down would just show Bob Lee? In the fnCreateSelect function (assuming you are using that) you would need to strip the HTML from the data that is used to build the select list. how do I disable the drop down menu for column five (in my case the column that has the edit and delete links)? Alter the caller of fnCreateSelect to not call it for the column(s) that you don't want it to operate on :-) Allan

Figured it out. [code] $("tfoot th#usedropdown").each( function ( i ) { this.innerHTML = fnCreateSelect( oTable.fnGetColumnData(i) ); $('select', this).change( function () { oTable.fnFilter( $(this).val(), i ); } ); } ); [/code] And the tag: [code] [/code] EDIT: Bleh. Not working as I thought it would. Data in dropdown menu is wrong. Like if I use this: [code] [/code] Dropdown menu 3 (under 4th column) shows data from 3rd column. This should be from fourth.

Hi Allan, I have the same points as dazell before: Thank you for that helpful tool! :-) Is there already a feature implemented or planned to export the datatable to an xml-file? I already prooved the TableTools, they do this kind of job only (sorry ;-) ) for xls, csv and pdf. Has anybody else a selfmade solution? Maybe dazell himself? Best regards Emme

try this url, http://datatables.net/forums/discussion/3931/server-side-filtering-on-specific-columns-with-input-and-select/p1

details? link? code? you're not giving us anything to go on

I agree. DT is a great product. I hope more people start using it and also support development with donations. I am not the author, or affiliated with the product. This is an honest endorsement.

Good point, I hadn't even considered that. I ended up with a solution where I keep track of how many records to skip on the server side, then preserve that number if the data was filtered so I can show the a subset of the same results on page 1. Thanks for the direction.