Search

My fault - typo on data

See, it's a testament to how ignorant of JS I am that it took me a good 15 minutes to figure what and where the console was. Turns out that there's two stupid syntax errors in the ?: statements (namely I actually have a '?' and a ':' right next to each other, without an expression between them). I then managed to work out the rest of the problems myself, thanks to the newfound console. :) Sorry to bother you with such trivialities, but at least it won't happen again. :P

hello megetron, i suppose you could use the column filter plugin by jovan popavic, there you can make all the adjustment on which rows need to be fileterd and which to be not. following is the link: http://jquery-datatables-column-filter.googlecode.com/svn/trunk/index.html Arjun

I should add that in my above example code I have listed "bAutoWidth" as being set to "treu". That is just a cut-and-paste error, in my code it is actually set to "true". Perhaps I should have added that I only want the table to be as wide as it "needs to be".

Hi Allan, Thanks for the info, but I actually figured that out (my solution was using .eq(1)). Using a id is not easy for me because I have multiple datatables, accros tabs, that requere the same behavior. So it's a lot easier when I can just rever to the .datatable in the current tab.

You are going to have to provide a while lot more information than that if we are to be able to offer any help whatsoever. See also: http://datatables.net/faqs#speed Allan

Have you looked at the bDestroy or fnDestroy options to remove the old DataTable, and then you can initialise a new one in its place? Allan

Hi Allan, After I posted this, I realized I was also having some weird indexing issues, where if I added rows from more than one page of the pre-populated table (which only shows 5 entries at a time) using fnAddTr, and then deleted them, fnDeleteRow(pos) would delete rows from actTable (their current table) based on the position of that row before it had been deleted from availTable (the original table) relative to pagination. So, for example, if I added the first row off of each page of availTable, and then went and deleted one of them from actTable, they would all be removed. But only one would reappear in availTable. So, last night, after I posted I went back and reworked my code to use fnAddData instead of fnAddTr. And that took care of all my issues. So I will probably stick with that for the time being, but next time I'm moving things back and forth I will take a look at the updated fnAddTr plugin. Otherwise this has been a fantastic product for me. Thank you!

i hope this will help. if not i will post the code.

datatable 1 and datatable 2 are completely different tables in html/datatables. it sounds like they will be completely different tables in the database as well. table 1 lists all orders table 2 allows you to list all parts of an order (all rows in table 2 that have a reference in some field to an order number) the call to oTable2.fnFilter() would be in whatever handler you are using to detect the user clicking on a row in oTable1. likely it is not specified within the initialization object of table1, but something like: [code] $(document).ready( function () { oTable1 = $('#table1').dataTable( // .... ); oTable2 = $('#table2').dataTable( // .... ); $('#table1 tbody tr').live('click', function() { // find the order number (I'm assuming it's in column 0 of every row) aData = oTable1.fnGetData(this); sOrder = aData[0]; // filter table 1 with this order number (assuming order number is in col 4 of table 2) oTable2.fnFilter(sOrder, 4); }) });[/code]