Search

Hi Fellaz! Please! I need your help. The standard sorting option does not sort the Column with German Umlauts the right way. Alaska Berta Egon Ägeri For example Ägeri should be at the first place. (ä = ae) Ägeri Alaska Berta Egon How can I manipulate the datatable config script or whatever to fix this issue? Thanx for helping a Datatable Beginner. Funkybrotha UPDATE! OK, I have found the solution here: http://www.datatables.net/forums/discussion/8348/filtering-and-sorting/p1 Thanx Phu!

What is the best way how to modify row column content, e.g. add a button? Now I am doing it with: "fnRowCallback" : function(nRow, aData, iDisplayIndex, iDisplayIndexFull) { $('td:eq(0)', nRow).html(... $('td:eq(1)', nRow).html(... DataTables load is very slow when I use this way. Is there any better way? I want to be able to add some buttons, input and so on. I'm using "bProcessing" : true, "bDeferRender" : true. Thank you

I am working with DataTables server-side processing http://datatables.net/release-datatables/examples/data_sources/server_side.html How can I add one column at the end like this picture is not? http://i.imgur.com/0Vq6uje.jpg Not used Editor. Please help me. I thank you very much for your enthusiastic help.

How will i go about doing it ? i mean fixed column plugin separate 1 table into 2, how do it do the sorting across 2 tables ?

This is my initialisation: $('#tablaOpciones').dataTable( { "aaSorting":[], "sScrollY": "180px", "bAutoWidth": false, "bPaginate": false, "bScrollCollapse": true, "bInfo": false, "bFilter": false }); The table cloumns in my table are almost the double wide than the content inside. I cant get rid of the X scroll, what can I use if bScrollAutoCss is now deprecated and the !important in the stylesheet had no effect. .dataTables_scrollBody{ overflow-x:hidden !important; }

Look at this : [code] var somevar = $('#somediv').dataTable({ "bProcessing": true, "bServerSide": true, "sAjaxSource": "someurl", ====> "aoColumnDefs": [ { "sClass": "center", "aTargets": [ 2 ] }, { "sClass": "right", "aTargets": [ 5,6 ] } ] }); [/code] What's the best practice to do this something like that ?

[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).