Search
11456 results 9021-9030
Forum
- 17th Aug 2012Move default filters into existing divHi 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
- 26th Jun 2012rowGrouping & footer column filtering working together?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?
- 9th Apr 2012Adding filtering function to a columnI 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
- 2nd Apr 2012TableTools with filtersHi! How can I save the values I've entered in the input fields in the pdf document using the TableTools? Thanks!!
- 30th Mar 2012Adding Filters to a Datatable which has source from a php FileHey 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
- 19th Jan 2012filtering latin words using server-sideHi 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
- 3rd Nov 2011Reset Filters ButtonI 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?
- 9th Mar 2011Individual column filtering (using select menus).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.
- 11th Nov 2010Individual column filtering - sort fields in select elementclick 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
- 27th Oct 2010Fixed columns with column level filtering in second header rowHi 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