Search

I just implemented Drill Down rows (http://www.datatables.net/blog/Drill-down_rows) on a datatable with the columnFilter plugin. The Drill Down rows require a column to be inserted for the open/close buttons. How can I exclude this column from the list of searchable rows by the columnFilter plugin? I've already excluded the column from global filtering with "bSearchable". My aoColumns: [code] "aoColumns" : [ { "mDataProp" : null, "mData" : null, "bSortable" : false, "bSearchable" : false, // exclude from global filtering "sClass" : "control center", "sDefaultContent" : '' }, { "mDataProp" : "browser", }, { "mDataProp" : "engine" }, ], [/code] Now, when i search the "browser" column, the column index is "sSearch_1" (it should be "sSearch_0" though, since the first column can't be searched). I tried adding a 'null' value for this column in the columnFilter() initialization but this doesn't solve the problem. [code] $('#example').dataTable().columnFilter( { "aoColumns" : [ null, {type: "text"}, {type: "text"} ] } ); [/code] Any help would be very much appreciated!

Hi, I have a table which is created using data table, the on-the-fly search for this table works great, but if I change any the column matching the search criteria and search again using the same search string, the previously changed row is still showing up. For ex: Say I have a table with column 'number' and it has 3 rows, the column values are 1, 2, 3. I search the table with value 1 and the row having 1 shows up and I change the value of 1 to 4. When I search the table again with 1, the row having value 4 shows up. It is like the dataTable is not seeing the changes to the table. Is there something that I am missing or is it a bug in dataTable ? Thank you, Shyam

Hello forum, i have a column with a date that i don't want to display, but i want to filter over a range on this column. Filtering is exactly like the example http://www.datatables.net/release-datatables/examples/plug-ins/range_filtering.html, and hiding the column like this example http://www.datatables.net/release-datatables/examples/basic_init/hidden_columns.html aoColumnDefs has the following value: [code]{ "bVisible": false, "aTargets": [ 7 ] }[/code] But when i run the code, the column is visible, but without any data. I think it is because the column is not visible, but the two input fields for the range filtering try to access them. Is there a way to solve this? Greets Steffi

Hello everyone, I started to use server side processing (for PHP/MySQL) but I have a problem. Before I displayed my Datatables like this : < table class="table table-striped" id="liste"> ............ <?php $sql="SELECT * FROM songs"; $req= mysql_query($sql) or die('SQL Error!'.$sql.''.mysql_error()); while($data=mysql_fetch_assoc($req)){ Now I use server side processing, but all data appear without style and without html_entity_decode function. I would like to display - into column 1 : bold text and use html_entity_decode. - into column 2: use nl2br and html_entity_decode. Do I have to edit this file : http://www.datatables.net/development/server-side/php_mysql Here is what I have done : $(document).ready(function() { $('#liste').dataTable( { "sDom": "tp", "bLengthChange": false, "iDisplayLength": 10, "bSort": true, "bSortClasses": false, "bProcessing": true, "bServerSide": true, "sAjaxSource": "pages/toto.php", "aoColumnDefs": [ { 'bSortable': false, 'aTargets': [ 1 ] }, ] } ); } ); Thank you

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.