Search

Hi Guys, I have a question about aoColumns. I figured it out...works great..thanks.

Currently I am able to get the full data from the first table, but when I add the data to the second table, the data that was hidden in the first table is still hidden in the 2nd table. I am using .fnAddData to add the row to the second table. Does anyone know how to get the data to show up? Thanks!

Hi to All, I want a dropdown in my screen and filter table dropdown selected list

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??

So I have looked around but failed to find anything relating to this. Is there any way I can use CSS sprites for my standard Data Table's sorting icons? Ideally it'd work just like jQueryUI, but without changing all the styles. The style I have written now is already done, and if I use jQueryUI I need to override almost everything that comes by default from jQUI which seems like a lot of extra work just to have these icons in a sprite. Thank you very much! P.S. Perhaps a plugin to affect rendering would allow this if it is not currently feasible or there's no built in switch, although I could see a lot of developers hanging themselves with that rope and then complaining to you about it so it may not be worth extending that far (and may negatively affect performance).

I am using a custom sSortDataType to sort input:text fields in the table. I am using the example for dom-text from this site. That pretty much works as expected until I hide and then unhide the sorted column. Apparently DataTables take the data from the custom sort and inserts it into its backing store destroying the original data. Not intuitively obvious that sorting will erase data. Seems to me that the display cache and the sort cache, for a custom sort, should be separate elements. Any advice on how to overcome this limitation.

I want to use this Add-On but it dosn't work! here is my code example!! [code] function CreateProductTable(TableHeader, ProductTable) { var aColums = []; var aVisible = []; var aColumnIndex = []; if (TableHeader != null) { for (var i = 0; i < TableHeader.length; i++) { var jColums = { sTitle: '', sType: '', bVisible: true }; jColums.sTitle = TableHeader[i].Parameter; var iDatenTyp = TableHeader[i].DataType; switch (iDatenTyp.toUpperCase()) { case "char": case "1": //is a character jColums.sType = ''; break; case "number": case "0": //is a number jColums.sType = 'numeric-comma'; break; } var sColVis = TableHeader[i].ColumnVisible; if (sColVis.toLowerCase() == "false" || sColVis == "0") { aColumnIndex.push(i); } //jColums.bVisible = false; aColums.push(jColums); } jQuery('#CPH_content_HF_HiddenColumns').val(''); jQuery('#CPH_content_HF_HiddenColumns').val(aColumnIndex); if (TableHeader.length != 0) { jQuery('#tableproduct').dataTable({ "sScrollY": "200px", "bJQueryUI": true, "bLengthChange": false, //show entries //"sDom": 'FT<"clear">lftFrip', // p = bPaginate, i = bInfo, t = , r = "iDisplayLength": 20, "bPaginate": true, //"sPaginationType": "full_numbers", "bProcessing": true, "bSort": true, "bFilter": true, "bAutoWidth": false, "bDestroy": true, "bInfo": true, "aaSorting": [], "aaData": ProductTable, "aoColumns": aColums, //dynamic TableHeader "oLanguage": {}, "aoColumnDefs": [ //{ "bSearchable": false, "bVisible": true, "aTargets": [9] } ], "fnRowCallback": function (nRow, aData, iDisplayIndex) { for (var i = 0; i < aData.length; i++) { jQuery('td:eq(' + i + ')', nRow).attr('id', 'CellIndex_' + i + '_RowIndex_' + iDisplayIndex); jQuery('td:eq(' + i + ')', nRow).parent().attr('id', 'RowIndex_' + iDisplayIndex); } return nRow; }, "fnDrawCallback": function (nRow, aData, iDisplayIndex) {//reinitialisierung von funktionen jQuery('#progressbar_table').hide(); initTableProductClick(); } }) .columnFilter({ ######################## here are the problems ############################# }); //TableHeader they are invisible / var oTable2 = jQuery('#tableproduct').dataTable(); for (var i = 0; i < aColumnIndex.length; i++) { var iCol = aColumnIndex[i]; var bVis = oTable.fnSettings().aoColumns[iCol].bVisible; oTable2.fnSetColumnVis(iCol, bVis ? false : true); } } } } [/code] Dosent understand what's wrong... please help me ...! Tank you Tank you ... best regards Alexander

There is some parameter that allows me to see the zeros? the td is 0.5 but the table shows me .5 !! appreciate the help

If you have a column without a caption, the DIV inside the TH shrinks to nothing so you end up clicking the TH instead of the DIV. The following line in _fnMouseDown [code] var nThTarget = e.target.nodeName == "TH" ? e.target : $(e.target).parents('TH')[0]; [/code] will normally find the appropriate TH fine because jQuery's parents() function is case insensitive, whereas the comparison between nodeName and "TH" is case sensitive. And this becomes a problem when the DIV shrinks to nothing because of no caption and you click on the TH directly. The solution is simple: force the case to either uppercase or lowercase. I used lowercase because it's more consistent and I don't like my TH's shouting at me! :) Modified code: [code] var nThTarget = e.target.nodeName.toLowerCase() == "th" ? e.target : $(e.target).parents('th')[0]; [/code]

Tried to use dataTables 1.8.0 and 1.8.2 but they don't align well. Also setting variable column widths works well in FF, chrome, Safari but fails in IE. I'm not sure if this is a dataTable issue or the issue with CSS Styling. The js code - $(document).ready(function(){ $('#example').dataTable( { "sDom": '<"top"fl>rt<"bottom"ip><"spacer">', "sScrollX": "100%", "sScrollXInner": "110%", "bScrollCollapse": true, "sPaginationType": "full_numbers", "bSort" : false } ); });