Search

is the column is sorted partially, the problem is

I came upon a post on "Data for Radicals" on making google spreadsheets searchable. This started me in the right direction. But I have a question regarding the post. Is there a way to alter the default "ascending" order of the first column of the table to be "descending"? I have the original post listed below is where I have gotten my information: "http://dataforradicals.com/the-absurdly-illustrated-guide-to-sortable-searchable-online-data-tables/" The page I am working on is : "http://www.udel.edu/gradoffice/academics/dissdefense-test4.html". I would like the "date" column to be the most current to least current, basically "descending order". If you could help I would appreciate it. Thanks again for your wonderful work. By the way I am very new to this so any help would be appreciated. Here is a link to the original tabletopfeed.js file that has a lot in there: "http://www.udel.edu/gradoffice/academics/scripts/tabletop-feed.js" David Barczak Communication Manager University of Delaware

Hi again. I have spotted that the sql order clause is not a public function in the editor class and we are supposed to use the client side ordering to achieve ordering. So far so good. I have added the id as a field on the php side and added the column to the datatable columns list (and told the class to hide the column). I get an issue from jQuery as follows: "TypeError: j[k] is undefined" I have also tried ordering client side using the DT_RowId data as sent in by the editor class - same issue. Its quite important that I order the client side table for my client with the id's from the db showing in descending order. Any ideas on how to make this happen?

I have the following table declared, but its not ordering by the 4th column (or the 3rd, for that matter, as the "order" parameter doesnt seem to work). Any tips? `var pmTablesSortable = $('table.datatable').dataTable( { "sDom": "<'row'<'span8'l><'span8'f>r>t<'row'<'span8'i><'span8'p>>", "order": [[ 4, "desc" ]], "bFilter": true, "bAutoWidth": false, "aoColumns": [ null, null, null, null, { "sType": 'currency' }, null, null, null ] } );`

Hi I want to have two column and many rows table with Data No. of row list and Search Column. function searchRows(tblId) { var tbl = document.getElementById(tblId); var headRow = tbl.rows[0]; var arrayOfHTxt = new Array(); var arrayOfHtxtCellIndex = new Array(); for (var v = 0; v < headRow.cells.length; v++) { if (headRow.cells[v].getElementsByTagName('input')[0]) { var Htxtbox = headRow.cells[v].getElementsByTagName('input')[0]; if (Htxtbox.value.replace(/^\s+|\s+$/g, '') != '') { arrayOfHTxt.push(Htxtbox.value.replace(/^\s+|\s+$/g, '')); arrayOfHtxtCellIndex.push(v); } } } for (var i = 1; i < tbl.rows.length; i++) { tbl.rows[i].style.display = 'table-row'; for (var v = 0; v < arrayOfHTxt.length; v++) { var CurCell = tbl.rows[i].cells[arrayOfHtxtCellIndex[v]]; var CurCont = CurCell.innerHTML.replace(/]+>/g, ""); var reg = new RegExp(arrayOfHTxt[v] + ".*", "i"); if (CurCont.match(reg) == null) { tbl.rows[i].style.display = 'none'; } } } } < div style="overflow:scroll;height:155px;width:70%;"> < table id="tblS" style="background-color:Aqua;" border="2"> Destination Rate(USD) Support 25 Oct 2011 Suuuuort 25 Oct 2012 Suuuuort 25 Oct 2012

Hello. I am wondering about the following functionailty within DataTables: Current form is HTML table DOM. Be able to select multiple rows within a table and drag and drop to a new location. Be able to select single / multiple rows within a table and drag and drop to a different table. Thanks.

I do not believe this is intended behavior. When a column header is clicked it activates jqueries .scroll event when the selected element is div.dataTables_scrollBody. [code] var limbo_queue = $('#queue').dataTable( { "sDom": "ltSi", "bScrollInfinite": true, "sScrollY": "466px", "aoColumns": [ { "sType": "numeric-html" }, null, null, null, null, null, null, null, null ] } ); $('div.dataTables_scrollBody').scroll(function(){ alert("I'm called!") })[/code] I'm running this with datatabels.js 1.9.4 and bootstrap 2.3.2.

For some time my application was getting a Javascript error: [quote]Microsoft JScript runtime error: Unable to get value of the property '1': object is null or undefined[/quote] on line 398 of KeyTable.js (as of 1.1.8.dev anyway) which reads: [code]var iRow = _fnFindDtCell(nTarget)[1];[/code] I figured it was a KeyTable problem that would be resolved, but it never went away, so it's probably my code. I scoured ~700 lines of Javascript but found nothing wrong. Then I started to Firebug code alongside the closest example: http://editor.datatables.net/tutorials/keytable To the point, my footers looked like this: "Content" whereas Allan's were properly using : "Content". My HTML was wrong. Not only was KeyTables not buggy, it was the only software that alerted me to a standards violation in my own application. (This post is intended for those that search for this issue in the future because the problem can be subtle).

I'm new to this so sorry for my lack of knowledge. I've set up a live example here: http://live.datatables.net/iyupes/ First off, I am trying to get the table to be searched by column. So you can enter a value for each column and it filters the results. Secondly I want those filters to search within a range rather than an exact number. So if I enter 1.8 I want it to show results within 0.5 (as an example. So anything in the range of 1.3-2.3 would still show. Lastly I want to move the search boxes for each column to the top of the table or even out away from the table. Your help is hugely appreciated!

the column to be sorted with 'A' appearing first