Search

title="Editor initialisation option">i18n initialisation options. See the internationalisation

a lot of input options such as radio buttons,

p>The title and message options of

and submitTrigger (and *Html) options of the

edit and row selection options are presented in the

to dynamically change the options in SearchPanes as the

add additional features and options to your DataTables. This

a large number of options. In such cases you

function to control the options label.

a large number of options to the end user.

I followed the "Join tables - one-to-many join" example, however in my case the select/checkbox fields for "Main Venue"/"Satellite Venue" are not filled with any data. Please see my test case on: http://live.datatables.net/befelofe/1/ Link to debugger info: http://debug.datatables.net/uraker Thank you in advance for any help :smile:

Hello, I am a bit new in the whole dataTables schema . So i would like to ask the community for some help . http://live.datatables.net/kikiqejo/1/ What I am trying to do in this jsBin is reload the data of the datatable every time that a user focuses on the page and paint the background color depending on a row variable . The dataset I have is random so i have to iterate through it and then apply the css of the backround color. The problem is that even if I am using bDestroy I cannot create the table with the extended Settings . Any ideas how to solve that please ?

I want to be able to get values for a 2nd filter, based on the rows returned from the 1st selected filter (not all rows prior to filtering). Can anybody help with this? Sorry I could not get the first part of code to indent: $.fn.dataTableExt.oApi.fnGetColumnData = function(oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty) { // check that we have a column id if (typeof iColumn == "undefined") return new Array(); // by default we only want unique data if (typeof bUnique == "undefined") bUnique = true; // by default we do want to only look at filtered data if (typeof bFiltered == "undefined") bFiltered = false; // by default we do not want to include empty values if (typeof bIgnoreEmpty == "undefined") bIgnoreEmpty = true; // list of rows which we're going to loop through var aiRows; // use only filtered rows if (bFiltered == true) aiRows = oSettings.aiDisplay; // use all rows else aiRows = oSettings.aiDisplayMaster; // all row numbers // set up data array var asResultData = new Array(); for (var i = 0, c = aiRows.length; i < c; i++) { iRow = aiRows[i]; var aData = this.fnGetData(iRow); var sValue = aData[iColumn]; if (sValue === undefined) continue; // ignore empty values? else if (bIgnoreEmpty == true && sValue.length == 0) continue; // ignore unique values? else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue; // else push the value onto the result data array else asResultData.push(sValue); } return asResultData; } function fnCreateSelect(aData) { var r = '<select><option value=""></option>', i, iLen = aData.length; for (i = 0; i < iLen; i++) { r += '<option value="' + aData[i] + '">' + aData[i] + '</option>'; } return r + '</select>'; } var oTable = $('#ActivityIndex').dataTable({ "sScrollY": calcDataTableHeight(), "iDisplayLength": 10, "bAutoWidth": true, "bPaginate": false, "bFilter": true, "aaSorting": [[6, 'desc'], [7, 'asc']], "aoColumns": [null, null, null, null, null, null, null, null, null, null, null, { "bSortable": false }, null], "bSortClasses": false }); $(window).resize(function() { var oSettings = oTable.fnSettings(); oSettings.oScroll.sY = calcDataTableHeight(); oTable.fnDraw(); }); $($("tfoot")[1]).find("th").each(function(i) { if ($(this).hasClass("filterable")) { //sorting but ignoring upper or lowercases this.innerHTML = fnCreateSelect(oTable.fnGetColumnData(i).sort(charOrdA)); $('select', this).change(function () { oTable.fnFilter(($(this).val() == "" ? "" : "^" + $(this).val() + "$"), i, true); }); } }); function charOrdA(a, b) { a = a.toLowerCase(); b = b.toLowerCase(); return (a > b) ? 1 : -1; return 0; }

Hi!, I have a problem with sorting. It only sorts like all data is string. Could you help me? Is there any solution with this case?

Is there an option to print multiple tables with one print button?

Could you pleas someone help to resolve above issue with dropdown icon. I have done using collection but it doesnt have the dropdown icon.

I want to add a reset button in datatable. my button and default buttons are looking different. can i use my buttons instead of export flash buttons?

Hi, I am having a datatable created like below $('#filterTable').dataTable({ "sDom": '<"top"l>rt<"bottom"ip><"clear">', "aoColumnDefs": [{"bSortable": false, "aTargets": [5]}] }).columnFilter({ aoColumns: [null, {type: "select"}, {type: "select"}, {type: "select"}, {type: "select"}, null], sPlaceHolder: "head:after" }); At loading time it has some data and select filter is displaying the record according to the current rows. I am adding new rows like "table.oApi._fnAddData(oSettings, json.data[i]);" Now i need the filter option to have the updated data according to new row also. Thanks.

Is it possible to display DataTables in such a way that only one column of information is shown. Then after a user selects a row additional columns of information from that row are displayed to the right in a new DIV? I'm looking for something similar to how Adobe SPRY HTML DataSets worked but with jQuery. I've tried looking in the examples and plug-ins but haven't found anything. The closest I came across was the DataTables Hidden Row Details example but I want the informtion to display to the right and now below the row that was expanded. Thanks in advance for any assistance or links to examples that I'm looking for. Dan

Hi there: I have the following code in a file called initializing_jquery_datatables.js: [code] $(document).ready(function() { $('.table').dataTable( { "sDom": "<'row'W<'row'<'col-md-6'l><'col-md-6'f>r>t<'row'<'col-md-6'i><'col-md-6'p>>T", "sPaginationType": "bootstrap", "bDestroy": false ... }); [/code] I filter and exclude some columns in another js file like this: [code] $.extend( true, $.fn.dataTable.defaults, { "oColumnFilterWidgets": { "aiExclude": [ 10 ] } }); [/code] And doesn't work