Search

Hi all, I'm normally a server side developer and I have a new Job which, though demanding I enjoy a lot as it is forcing me to polish my clitent side skills! So the problem I have is this, I have a page that displays a LOT of data, the previous developer used Data Tables to display new user data. We can do all the things that a Data Table normally displays, I can filter etc. But the problem I have is when adding a new user a modal light box opens and we edit/add a new user, the user saves and the page reloads to include the new/edited user data in the revised table. and this is the crux of the issue. How can I save the previous state of the table and reload in its previous state? I really want to ajax this so that there does not need to be a full page refresh (it was written originally to load up hundreds of tables, I am rewriting so that each tab click loads the table when a tab is clicked. I can use a lightbox correctly to store the data without having to perform a redirtect or a page refresh, what I need to happen is when the lightbox closes the data table refreshes to reflect the new changes while staying in the same order and on the same page. Seriously any help or any pointers would help a great deal. Jim

I am using datatable with bootstrap and I have applied the recommended adjustemnets. However I cannot remove from datatables the violet column highlight on sorting. Any suggestion?

to write a customized sorting method for one of

object but many rows, sorting and searching doesn't work.

JQuery's DataTables has very poor docs. So sorry for maybe trivial question. I want for filter my table by some string on some column. Here is mine code: [code] var str = "days"; my_table.fnFilter(str, 9); [/code] I expect to have only rows that contains "days" string at 9 column (counting from 0). But above code does not bring me result I have tried to use this code with RexEx: [code] var regEx = "days"; my_table.fnFilter(regEx, 9, true); [/code] this code: [code] var regEx = "^days$"; my_table.fnFilter(regEx, 9, true); [/code] and this code: [code] var regEx = ".days."; my_table.fnFilter(regEx, 9, true); [/code] All without luck. I am sure my table has "101 days" string at 9 column. What am I doing wrong? I have custom type for my column: [code] jQuery.fn.dataTableExt.oSort['days-asc'] = function (a, b) { var x = parseInt((trim(a) == "") ? 0 : trim(a.replace(/days/, ""))); var y = parseInt((trim(b) == "") ? 0 : trim(b.replace(/days/, ""))); return ((x < y) ? -1 : ((x > y) ? 1 : 0)); }; jQuery.fn.dataTableExt.oSort['days-desc'] = function (a, b) { var x = parseInt((trim(a) == "") ? 0 : trim(a.replace(/days/, ""))); var y = parseInt((trim(b) == "") ? 0 : trim(b.replace(/days/, ""))); return ((x < y) ? 1 : ((x > y) ? -1 : 0)); };[/code]

Disregard. wrong question :)

Please, I need to display the results sorted in ascending order on the fifth column if the typed search string is of type integer, otherwise sorted on the first column. how can I do it? Thank you.

any columns) and the sorting info applied. Is it

I'm hoping this is just a case of me overlooking the obvious, but I'd like to suppress the up/down arrows which appear in the headers of sortable columns when JQuery UI support is enabled. I've got the following code, but it seems to have no effect (other lines removed for clarity): [code] $.extend($.fn.dataTableExt.oJUIClasses, { "sSortable": '' }); $('#txnTable').dataTable({ "bJQueryUI": true });[/code] Any help would be appreciated? Thanks Mark

when the table is sorted. This is the first