Search

szymon, It has been fixed as of the 1.0.6 nightly of ColVis, more info here: http://www.datatables.net/forums/discussion/comment/22562#Comment_22562 Cheers, CHgsd

That's awesome - thanks! I'll have a closer look at the pull request in the next few days. Regards, Allan

numberone, I'm using server side processing with PHP 4.x so not JSON version. I have SQL working for non-DataTables but can't figure out how to make my SQL work with DataTables and hoping your solution can work. I have one table (po_spots) that can have multiple date ranges (launchdate) grouped with a primary key value (ponumber). I need to find the earliest date within that group and eventually assign as 'mindates.' Then join with table po_gen_info. Like I said, my SQL statement is working but not with Datatable. Working SQL is: [code] SELECT po_gen_info.client,po_gen_info.promotitle,po_gen_info.projectlead,po_gen_info.station_kamx,po_gen_info.station_kkmj,po_gen_info.station_kjce,mindates.* FROM ( SELECT ponumber , MIN(launchdate) AS earliestdate FROM po_spots WHERE produced != 'Yes' GROUP BY ponumber ) AS mindates INNER JOIN po_spots ON po_spots.ponumber = mindates.ponumber AND po_spots.launchdate = mindates.earliestdate INNER JOIN po_gen_info ON po_spots.ponumber = po_gen_info.ponumber GROUP BY ponumber ORDER BY mindates.earliestdate [/code] Can your approach work for me and if so can you please give me examples I can try? Thanks,

Thanks, allan. "bVisible": false did the trick.

i fixed the problem with multi sorting.. old one : [code] for($i = 0; $i < intval($this->ci->input->post('iSortingCols')); $i++) $sOrder .= $columns[intval($this->ci->input->post('iSortCol_' . $i))] . ' ' . $this->ci->input->post('sSortDir_' . $i) . ', '; [/code] fixed one: [code] $sColumnsArray = explode(',', $this->ci->input->post('sColumns')); for($i = 0; $i < intval($this->ci->input->post('iSortingCols')); $i++) $sOrder .= $sColumnsArray[intval($this->ci->input->post('iSortCol_' . $i ))] . ' ' . $this->ci->input->post("sSortDir_" . $i) . ', '; [/code]

Awesome! Working now, TYVM!

Have you corrected the HTML issues that the validator flags up? In the example you linked to there are still the same issues. DataTables requires valid HMTL in order to work, otherwise the number of options that would need to be supported would just be impossible. Allan

Im afraid not at this time. This would be implemented as a plug-in to DataTables, but it's not one I've had time to create yet. Allan

Thanks Allan. That was indeed the problem. I was not constructing my header properly. Now it works perfectly fine! Thanks again.

At the moment - no not really. If you want to do any meta data stuff, then you'll need to do it manually, or assign it to DataTables' internal components in such a way that DataTables doesn't know about it (easy enough using the aoData array). Regarding the header - DataTables does very little to the table headers, so there are no manipulation functions for them. Rather, what is expected is that if you want to manipulate the headers, just do it using standard DOM / jQuery methods. Allan