Search

I have gone through the column sorting in jQuery datatable and the various ways of controlling it.. I have a query is it possible to control sorting in such a way that clicking on upper arrow icon will do sorting in ascending order & down arrow icon will do sorting in descending order,when both the icons are visible at the same time??

Can anybody please tell me how to exclude a column in the Copy, Excel, Pdf option??? :-Abhishek

vertical scrolling is not working when i gave colspan to a raw .Is there any way to do that thanks

This seems strange: http://jsfiddle.net/y5d3b/ Some of the TD elements have empty DIV elements and it seems to be breaking the sorting. Is this expected behavior? Is there a way around it?

Hi, I am using check box to each of the row to select that row . And also having a checkbox in that column Header to select all the row which are displaying . If there is a 5 out of 10 records are displaying I need to select those 5 record only when i am clicking on Header checkbox and also check Box must get checked of those 5 records. If there is option in the script Please help me solve this issue . thanks in advance. Thanks & Regards , Thamaraiselvan

Hi As the Title suggests i need to find out if sort function is enabled will datatables support checkbox generated from Struts 2 tag more specifically from Iterator can u give me an example which i can refer

I just got back to my DataTables editor project and still have some work to do to figure out how the JSON for joined tables is made and especially used. Is duplication of these rows required? (two copies of "Printer" value) [code] "access":[ { "value":"1", "0":"1", "label":"Printer", "1":"Printer" } ] [/code] Or here: ("Printer" and a numeric id, same as above) Should mData be used to read from the above object here instead of repeating it? [code] { "DT_RowId": "row_8", "first_name": "Bryar", "last_name": "Long", "dept": { "id": "1", "name": "IT" }, "access": [ { "id": "1", "name": "Printer" } ], "extra": { } }, [/code] I find duplication inherently confusing. What happens if "label":"Printer" is changed to "label":"snarfblat", for example? There are still other copies with the text, "Printer". Where is the "label" key from the "access" object (the one at the top of this post) used? Sorry, I'm having a really hard time with this. As I mentioned in a previous post, I don't use PHP so have to generate the JSON manually.

Hi, I am new to datatable. I will be thankful if somebody help me reqarding the below request. Problem : There is a requirement in which i needs to display the certain data in a cell of a row in different colour so that when user do the sorting or filtering of that coloumn the colour coading will be visible and make Row of data standout. Thanks for your quick response.

see: http://property2.webbox.co.za/template/velocityOnly,DataTables.vm print button works, but none of the others do. would very much appreciate someone telling me what i'm doing wrong. http://debug.datatables.net/awesev thanks in advance

Using server side processing I need to render column headings on the fly with some kind of callback when the ajax call is successful. I searched and found this: http://datatables.net/forums/discussion/3442/x&page=1#Item_10 But this will break the server side rendering. Something like this: [code] Untitled Document var display_options = {"wo_status":"Status","wo_number":"WO #","org_wo_num":"PPW #","date_created_print":"Date Created","date_received_print":"Date Received","ready_submission_date_print":"Ready Office","date_due_print":"Date Due","date_due_client_print":"Client Date Due","date_complete_estimate_print":"Estimated Complete Date","date_cancel_print":"Cancel Date","client_company_name":"Client","customer_name":"Customer","loan_number":"Loan #","loan_type":"Loan Type","address":"Address","city":"City","state":"State","zip":"Zip","county":"County","lot_size":"Lot Size","lock_code":"Lock Code","inspector_name":"Contractor","category_name":"Category","admin_name":"Admin","work_type_name":"Work Type","invoice_num":"Invoice #","invoice_date_print":"Invoice Date","photos":"Photos"}; var oTable = jq('#work_orders').dataTable({ "bStateSave": true, //"aaData": json_arr, //"aoColumns": aoColumns, "bDeferRender": true, "bProcessing": true, "bServerSide": true, "sAjaxSource": '', // Need a function like this to render column headings before further processing "fnAjaxSuccess": function(aoData){ //Loop through headings sent from aoData var columns = []; // Look at first row sent down for columns for (column in aoData[0]){ columns.push(column); } //Loop through sent headings, create aoColumns for (var i=0;i -1) ? 'us_date' : ''; //oColumn.sDefaultContent = 'TEST'; oColumn.fnCreatedCell = function (nTd, sData, oData, iRow, iCol) { //jq(nTd).wrapInner(''); } if (typeof oColumn.sTitle != "undefined"){ oColumn.sTitle = oColumn.sTitle.replace(/(]+)>)/ig," "); } oColumn.bVisible = (jQuery.inArray(columns[i], hidden_columns) > -1) ? false : true; oColumn.bSearchable = true; aoColumns.push(oColumn); } } }); [/code]