Search

I have a scenario to sort a column having multiple type of elements, drop-down list and string(HTML) type. I want to sort that particular column containing drop-down list and HTML type of data. This is what I Have tried using "orderDataType": "dom-select" and "sType": 'html' $.fn.dataTable.ext.order['dom-select'] = function (settings, col) { return this.api().column(col, { order: 'index' }).nodes().map(function (td, i) { return $('select', td).val(); }); } But only the string is sorting. The drop down list is not sorting. Please give me suggestions

Hi everyone. Liked the idea of such plugin, but i can not implement it. I receive JSON data from servlet and it reads number of rows and number of rows that should be displayed but after that shows such error as noted in the title. Link to jsfiddle with data https://jsfiddle.net/reghor/4r5350ge/1/. Sorry but idk how to connect json data to datatable on jsfiddle, i wrote in raw format( how i receive it from servlet).

Greetings, I am using the legacy api and curious if there is an elegant way of cloning a row which has columns that are hidden during a drag/drop event? It seems that a drag drop only captures the .innerHtml of the row in transit so it does not see the hidden column of the row. Does anyone have experience with this? var HelpMe= function (event, ui) { debugger; var noWorky = tbleSource..$('tr.row_selected'); ui.children().each(function () { $(this).width($(this).width()); }); return ui; //does not include hidden rows }; $("#tblTarget tbody").sortable({ helper: YetToBeDefined, }).disableSelection(); $("#tblSource tbody").sortable({ helper: HelpMe , connectWith: "#tblTarget tbody" }).disableSelection();

Is it possible to use buttons or links outside tabletools to generate an export (and bypass the included button menu). For example; Export to Excel Thanks!

I am using jquery datatables . http://jsfiddle.net/s3j5pbj4/2/ I am populating around 3000 records in paginated table.Problem is that If am selecting few checkbox and dropdown in first page and move to next page (by clicking on paginated next button) and again come back on first page , selected data is getting reset again (i.e. lets say every paginated page shows 10 rows on each page and if I have selected 5 rows on first page and then navigate to next page and again come back to first page selected row's data gets reset again). I want my user should be able to see what all selection he made on any page and then submit . Am i am doing something wrong here? $(document).ready(function() { var oTable = $('#dbResultsTable').dataTable({ "sPaginationType": "full_numbers" , "paging": true, "ordering" : true, "scrollY":false, "autoWidth": false, "serverSide": false, "processing": false, "bDeferRender": true, "info": true , "lengthMenu": [[10,25,50 ,100, -1], [10,25,50, 100, "All"]], "scrollX": "100%" , "aoColumns":[ { "mDataProp": null}, { "mDataProp": "operation"} ], "sAjaxSource" : "ResultPopulator", "bJQueryUI" : true, fnRowCallback : function(nRow,aaData, iDisplayIndex) { jQuery('td:eq(0)', nRow).html('<input id="checkId_' + nRow+ 'name="" type="checkbox")>'); var operationString = '<select name="operation" >'; operationString = operationString + '<option selected disabled hidden value=""></option>'; for ( var i = 0; i < aaData.operation.length; i++) { operationString = operationString+ '<option>' + aaData.operation[i]+ '</option>'; } operationString = operationString + '</select>'; jQuery('td:eq(1)', nRow).html(operationString); return nRow; }, } ); function validateFields(){ var status = true; var rowSelected = false ; var rows = $("#dbResultsTable").dataTable().fnGetNodes(); for (var i = 0; i < rows.length; i++) { var cells = rows[i].cells; if(cells[0].children[0].checked){ rowSelected = true; var operation = cells[1].children[0].value; if(operation==""){ var msz = " Please select an operation" status = false ; printMsz(msz); break; } } }

how can we develop to add a new column in datatable in editable mode and readable mode which depends on some conditions

Hi I am facing issue with multiple column reorderings. Here is the js bin link for the short demo.(http://live.datatables.net/butitesi/1/edit?html,css,js,console,output) There in the demo we have two buttons which will set the column ordering. If we click individual buttons , the ordering is fine. The problem is if we click the buttons in the sequence then finally what we have set is not ordered correctly. Could you guys help me out what is happening ...... Thanks in advance.

please tell m.....

Hi, https://datatables.net/examples/plug-ins/dom_sort.html As like in the above demo, I have one Amount column. And while displaying the amount we are applying the comma separated for the amount. Then we found that the sorting is not working. Please give some valuable solution for this issue. Regards Santosh

I find this disc.: http://datatables.net/forums/discussion/9468/how-can-i-export-data-to-txt but it saves with quote mark. I need without the quotes. Code, that I use: $('#table_users').dataTable( { "dom": 'T<"clear">lfrtip', "oTableTools": { "sSwfPath": "http://datatables.net/release-datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf", "aButtons": [{ "sExtends": "csv", "sFileName": "uids*.txt", "sButtonText": "save txt" }], "oSelectorOpts": { page: 'current', "filter": "applied" } } } ); Sorry for my english and sanks :)