Search

[code] var $datatable = $('table').dataTable(); $datatable.fnFilter( 'field0string', 0, true); $datatable.fnFilter( 'field1string', 1, true); [/code] I think this will filter the first field, and then treat the second field as a sub-filter (eg 'and'-filtering). What's the proper way to 'or'-filter, which would return records where field0 contains 'field0string' OR field1 contains 'field1string'. Browsing [older] forum posts, it looks like it was suggested to abuse the sSearch, but that is especially problematic if the same values may exist in other fields. Please let me know if this is confusing. I didn't think an example was necessary as it doesn't show the problem.

Sorry for asking too general question but I can't figure this one out. Let's say I have list of schools, colleges and universities with addresses located in different States. All that is in MySQL table and I can display that in the Datatable with server side processing. Now I need to filter those. I may need to display all schools addresses in 5 selected States, or I need to display all schools and Universities in one selected State. There could be many different combinations. I can make a separate form (probably a Modal window) with buttons or check boxes for all the 50 States and for all types of educational organizations I have. When user done with selection I can read that with JavaScript and pass it on. But the question is where should I pass it? I can probably destroy the table each time and initialize it with a new server-side URL parameters. Is there a better way?

I cannot for the life of me figure out why this is not working in Firefox but is working in Chrome/IE http://tinypic.com/r/903mhi/5 Usually when I scroll down to the abs bottom or abs right of a fixed header table the last row/column becomes out of alignment to accommodate for the scrollbars and realigns as i scroll back up/left. But firefox doesn't seem to be doing this at all. It just seems to push everything out of sync. Any ideas?

For some time my application was getting a Javascript error: [quote]Microsoft JScript runtime error: Unable to get value of the property '1': object is null or undefined[/quote] on line 398 of KeyTable.js (as of 1.1.8.dev anyway) which reads: [code]var iRow = _fnFindDtCell(nTarget)[1];[/code] I figured it was a KeyTable problem that would be resolved, but it never went away, so it's probably my code. I scoured ~700 lines of Javascript but found nothing wrong. Then I started to Firebug code alongside the closest example: http://editor.datatables.net/tutorials/keytable To the point, my footers looked like this: "Content" whereas Allan's were properly using : "Content". My HTML was wrong. Not only was KeyTables not buggy, it was the only software that alerted me to a standards violation in my own application. (This post is intended for those that search for this issue in the future because the problem can be subtle).

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]