Search

Awesome. Thanks fbas!

Hi Thomas. I'm in the UK, apologies for all references to 'UK' in this answer; the plugin you need should also work for German people! I have just put a test site together with a UK/German date formatted column on all tables. There are plugin scripts for 'detection' of UK format dates, but I have a problem believing that any script can know that 11/12/2011 and 12/11/2011 are UK/German rather than US. So I think you need the sorting plugin and to declare that the sType of your first column is "uk_date". You'll need the Date(dd/mm/yy) plugin from http://datatables.net/plug-ins/sorting and to give the script a file name such as the "ukdatesort.js" that I used. Those little icons help with copying the code into Notepad (or whatever text editor you use to make your own script file), btw. My own code, with the fifth column having the date, is: [code] $(document).ready(function(){ $('.dataTable').dataTable( { "bPaginate": false, "bLengthChange": false, "bAutoWidth": false, "bFilter": false, "bSort": true, "bInfo": false, "aoColumns": [ null, null, null, null, {"sType": "uk_date"}, null ] } ); }); [/code] Hope something equivalent to that works for you.

This one is also solved. I did following change in 'if' block on line 264 of jquery.dataTables.js file : [code] if ( !oSettings.bJUI ) { nPrevious = document.createElement( 'div' ); nPrevious.innerHTML = ''; nNext = document.createElement( 'div' ); nNext.innerHTML = ''; } [/code] Also removed the four images of prev and next from the CSS file.

Hi proair, The two numbers you have in those cells certainly look correct and should be identified as numbers by DataTables. Is accurate for all rows in your table (i.e. no empty values, no while space, no commas in larger numbers for formatting etc)? Thanks, Allan

Hi, for anyone trying to restore the old look here is my attempt: table.dataTable thead > tr > th.sorting:before, table.dataTable thead > tr > th.sorting:after, table.dataTable thead > tr > th.sorting_asc:before, table.dataTable thead > tr > th.sorting_asc:after, table.dataTable thead > tr > th.sorting_desc:before, table.dataTable thead > tr > th.sorting_desc:after, table.dataTable thead > tr > th.sorting_asc_disabled:before, table.dataTable thead > tr > th.sorting_asc_disabled:after, table.dataTable thead > tr > th.sorting_desc_disabled:before, table.dataTable thead > tr > th.sorting_desc_disabled:after, table.dataTable thead > tr > td.sorting:before, table.dataTable thead > tr > td.sorting:after, table.dataTable thead > tr > td.sorting_asc:before, table.dataTable thead > tr > td.sorting_asc:after, table.dataTable thead > tr > td.sorting_desc:before, table.dataTable thead > tr > td.sorting_desc:after, table.dataTable thead > tr > td.sorting_asc_disabled:before, table.dataTable thead > tr > td.sorting_asc_disabled:after, table.dataTable thead > tr > td.sorting_desc_disabled:before, table.dataTable thead > tr > td.sorting_desc_disabled:after { top: 0.5em; bottom: 0.5em; opacity: 0.3; line-height: 1.5em; font-size: 1em; } table.dataTable thead > tr > th.sorting:before, table.dataTable thead > tr > th.sorting_asc:before, table.dataTable thead > tr > th.sorting_desc:before, table.dataTable thead > tr > th.sorting_asc_disabled:before, table.dataTable thead > tr > th.sorting_desc_disabled:before, table.dataTable thead > tr > td.sorting:before, table.dataTable thead > tr > td.sorting_asc:before, table.dataTable thead > tr > td.sorting_desc:before, table.dataTable thead > tr > td.sorting_asc_disabled:before, table.dataTable thead > tr > td.sorting_desc_disabled:before { right: 1em; content: "\2191"; } table.dataTable thead > tr > th.sorting:after, table.dataTable thead > tr > th.sorting_asc:after, table.dataTable thead > tr > th.sorting_desc:after, table.dataTable thead > tr > th.sorting_asc_disabled:after, table.dataTable thead > tr > th.sorting_desc_disabled:after, table.dataTable thead > tr > td.sorting:after, table.dataTable thead > tr > td.sorting_asc:after, table.dataTable thead > tr > td.sorting_desc:after, table.dataTable thead > tr > td.sorting_asc_disabled:after, table.dataTable thead > tr > td.sorting_desc_disabled:after { right: 0.5em; content: "\2193"; } table.dataTable thead > tr > th.sorting_asc:before, table.dataTable thead > tr > th.sorting_desc:after, table.dataTable thead > tr > td.sorting_asc:before, table.dataTable thead > tr > td.sorting_desc:after { opacity: 1; }

How can I get the REAL row position , I do this: console.log( 'Row index: '+tbl_proy.row(this).index()); And it drop the 54 value, but the row is in the second position in the table. I need this value (2) not (54). Thanks

Hello, I'm working with a huge table, and i want to use it without AJAX at the moment, and being slow is not a huge deal, as i'm using a loading animation, so it would be fine, except that it's blocking the browser while it's doing it's filtering. So the way i would resolve this issue normally, is that i would run the filtering in blocks with little break times async, so the rest of the browser could respond to the other actions, and would seem like it's running on another thread... The problem is, that i'm not sure how can i wrap this solution around the current architect of the table. Is there any way to solve this issue? PS: I'm aware that ajax would solve this issue, but i'm interested in a solution without ajax.

hi i am using orderfixed for rowgroup and i

Hello, I am working with datatables and using rows grouping option. In fact, the row grouping depends on the values that exist on the columns by displaying: column name: value. The feature works fine when all columns are displayed (rows grouping maintains the good values when performing sorting columns). But when I hide some columns of my datatable (using ColVis option) and apply the sorting in any column of the grid, the grouping values change by taking values from other columns. For example: When displaying the grid with the following columns (the grid contains many other columns which are hidden), the Grouping of rows works fine: it groups by the values of Urgency column ID Title Urgency Number Urgency: * None * 1 TEST 1 * None * 60000 2 TEST 2 * None * 65485 Urgency: High/Yes 3 TEST 3 High/Yes 60045 4 TEST 4 High/Yes 65455 Urgency: Low/No 5 TEST 5 Low/No 70000 6 TEST 6 Low/No 67775 Once I sort the grid by any column (ID or Title or Urgency or Number), the rows grouping is broken and takes the following values: ID Title Urgency Number Urgency: Resolved 6 TEST 6 Low/No 67775 5 TEST 5 Low/No 70000 Urgency: in progress 4 TEST 4 High/Yes 65455 2 TEST 2 * None * 65485 Urgency: Opened 3 TEST 3 High/Yes 60045 1 TEST 1 * None * 60000 In fact when I sort by Title Column , the grouping takes values of a hidden column called Status (Resolved, in progress, Opened). Any Idea ?

rows and I need ordering for the child rows