Search

Hi there! Just wondered if this was possible? Basically I want to have complete control over the position of the filtering elements so I can render them inside another div element on the page. Thanks

Has anyone been able to get rowGrouping plug-in to work with individual column filters in the footer? It seems the rowGrouping throws off the indexing. Anyone have a working example of them together?

I have a table which have information which I would like to exclude from the search box. For example, in one of the columns I have some text and then links, it looks like that: [code] John Doe View | Edit | Delete [/code] Of-course in this case I would like the search box to consider only "John Doe" as a text to be searched. I draw my table in php (I use Symfony-2) and apply the DataTable plugin using dataTable function with jQuery. I got the impression that what I want is possible, but couldn't manage to achieve it. Other discussions like http://www.datatables.net/forums/discussion/255/customising-the-way-the-filter-works/p1 neither helped me to solve this problem. Thanks! Guy

Hi! How can I save the values I've entered in the input fields in the pdf document using the TableTools? Thanks!!

Hey Buddy i have a trouble here.This is my code here. I want to do column based/cell based filtering.I have datasource from a php file.Where exactly should i pass the ajax_source ('sAjaxSource':'table_data.php') parameter?? Kindly help //HTML code ; @import " datatables/media/css/demo_table.css"; table{width:100%} < script> (function($) { $('#the_table').dataTable({ 'sAjaxSource':'table_data.php' }); /* * Function: fnGetColumnData * Purpose: Return an array of table values from a particular column. * Returns: array string: 1d data array * Inputs: object:oSettings - dataTable settings object. This is always the last argument past to the function * int:iColumn - the id of the column to extract the data from * bool:bUnique - optional - if set to false duplicated values are not filtered out * bool:bFiltered - optional - if set to false all the table data is used (not only the filtered) * bool:bIgnoreEmpty - optional - if set to false empty values are not filtered from the result array * Author: Benedikt Forchhammer <b.forchhammer /AT\ mind2.de> */ $.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 wany unique data if ( typeof bUnique == "undefined" ) bUnique = true; // by default we do want to only look at filtered data if ( typeof bFiltered == "undefined" ) bFiltered = true; // by default we do not wany 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]; // ignore empty values? 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; }}(jQuery)); function fnCreateSelect( aData ) { var r='', i, iLen=aData.length; for ( i=0 ; i<iLen ; i++ ) { r += ''+aData[i]+''; } return r+''; } $(document).ready(function() { /* Initialise the DataTable */ var oTable = $('#the_table').dataTable( { "oLanguage": { "sSearch": "Search all columns:" } } ); /* Add a select menu for each TH element in the table footer */ $("tfoot th").each( function ( i ) { this.innerHTML = fnCreateSelect( oTable.fnGetColumnData(i) ); $('select', this).change( function () { oTable.fnFilter( $(this).val(), i ); } ); } ); } ); BusNO BusType Departure Arrival Seats SeaterFare

Hi All, I received no data when I search a latin word (example: aquisição) using processing server-side (with ASP classic). Checking the firebug I detected than my word was sent as 'aquisi%C3%A7' (original is aquisiç, with 'ç') I put this url in a browser: http://localhost/qry/qry_resultado.asp?sEcho=8&iColumns=4&sColumns=&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&sSearch=aquisi%C3%A7&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&iSortingCols=1&iSortCol_0=0&sSortDir_0=asc&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&_=1326988279015 I received no data. After this I noticed that aquisi%C3%A7 was converted to 'aquisiç' and in a next reload, the word was converted again but to 'aquisi%E7' then i get datas with 'aquisi%E7'. Can anyone help me? Sorry my english ;) Wilson

I have a custom RESET button that resets all my search values, clears my url, and resets my table, but I can't figure out how to restore hidden columns that were hidden with the ColVis plug-in. Anyone figured out how to do this?

Hello. I want to make tables on WP like this example: http://www.datatables.net/examples/api/multi_filter_select.html. But I can't undesrtand how to add initialisation code. I read this forum durind 2 days but can't find need information. Sorry for my english.

click on the "select" element beneath the column "Browser" in this example. It isnt sorted, how can I sort the fields alphabetically. --> http://datatables.net/examples/api/multi_filter_select.html the data is created here: [code] function fnCreateSelect( aData ) { var r='', i, iLen=aData.length; for ( i=0 ; i<iLen ; i++ ) { r += ''+aData[i]+''; } return r+''; } [/code] thanks in advance

Hi Allan, Just want to know if you have tried out Fixed columns plugin with multiple header rows. I am trying to fix first two columns, and my table have input text fields in the second row of the header. When it renders, it is giving some issues: 1) There is additional cloned header for two columns over the original header row, but first cloned column header is not visible. 2) One more unexpected thing is that the second header row with text fields is also cloned and it is visibly fixed when horizontally scrolled. Please suggest how to get rid of the above issues to make first 2 columns fixed. The table looks as below: Col1 Col2 Col3   And initialization as follows: myTable= $("#mytable").dataTable( { "sScrollX" : "100%", "sScrollY" : 1, "bAutoWidth" : true, "bProcessing" : true, "bJQueryUI" : true, "bPaginate" : false, "bSortClasses" : false, "bRetrieve" : true, "aoColumns" : [ { "bSortable" : false, "bSearchable" : false }, null, null, null, null, null, null, null, null, null, null, null, null, null,null,null], "aaSorting" : [], "oLanguage": { "sZeroRecords": "No records to display", "sInfo": "Count: TOTAL ", "sInfoEmpty": "Count: 0 ", "sInfoFiltered": "of total MAX ", "sInfoPostFix": "records" } }); new FixedColumns( myTable, { "columns": 2 }); Regards, Sriram