Search

Hi, I want to sort a column which is created dynamically. I can not use stype and aoColumns and i also want to use custom sort for example percentage . Any help ? I apreciate your answers.

Title says it all. I get aria-labels and controls but no actual class on th elements. I do see a span that changes class based on triangles, but these aren't really styleable for my needs. I need to add a background color to the th that is sorting.

Hey, I am kinda new to datadables and, first of all, have to say that this project is awesome! :-) Anyway i have big performance issues in the Internet Explorer when i try to display tables with ~3500 rows. it takes about 1 Minute to load the Table. In Firefox / Chrome it takes about 3-5 seconds. I use datatables @version 1.9.4 I am loading the table with a php function and i get the data from a mssql database: [code] AP-Nummer Edit Delete Edit Delete [/code] [code] $('#table_zitd').dataTable({ "aLengthMenu": [ [5, 15, 20, -1], [5, 15, 20, "All"] // change per page values here ], // set the initial value "iDisplayLength": -1, "sDom": "<'row-fluid'<'span6'l><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>", "sPaginationType": "bootstrap", "oLanguage": { "sLengthMenu": "MENU records per page", "oPaginate": { "sPrevious": "Prev", "sNext": "Next" } }, "aoColumnDefs": [{ 'bSortable': false, 'aTargets': [1,2] } ] }); [/code] Is there anything i can do to get this script running in the internet explorere?

hello all. I have a problem. I have my table with 2 filters select type. Now I want to move the filter to another location in the table. How can I do? David

Hello, I have an issue with my datatables. All the data is put in a database and I'm using server-side processing. My issue is about column filtering. If I try to filter one column everything is working ok. If I try to filter another column, I don't get any results. Here is a link http://stilbarbatesc.ro/ag2/test/ I used firebug to see what's up when filtering on the second column and on every search I get this [code]{"sEcho":80,"iTotalRecords":"4228","iTotalDisplayRecords":"5","aaData":[]}[/code] The only thing that changes on the above line is the sEcho which has different values. If there are needed certain files to be posted please tell me.

So I tried to recreate functionality on Data Tables where the first column and first row of an HTML table are fixed. http://datatables.net/release-datatables/extras/FixedHeader/zIndexes.html However, if you play with the example I coded up: http://joelin.org/work/Navigation/ , you'll see the leftmost column isn't formed correctly (the first element in the table header is too short). What might be going on? The code is summarized below. I think the issue is that the height of the 's row in the left column isnt getting set while the height of the 's row in the left column is being set by the JS. [code] td,th { background-color:white; border:black 1px solid; } <script> $(document).ready(function () { var myTable = $('#jsonDataTable').dataTable( { }); new FixedHeader(myTable, {"left": true, "zLeft": 105}); }); </script> <div id="tableContainer"> < table id="jsonDataTable"... [/code]

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