server-side processing example with hidden row information

rlcrom

I don't know if I'm missing something here or not. Could someone help me with the server-side processing example with hidden row information? The example shows the data in the hidden area that is in the main table. Thus really not hidden data. So, I want to display five columns of data on the display view and then show 8 more in the hidden view. My serverside JSON is returning all the data for all 13 columns.
I get an error about column counts not matching if I leave my column code with only the 5 columns that I want to display. If I add the extra columns, I see all my data in the datatable.

So my question is how do I get data to be hidden without displaying it on the visiable table first?

Here is my table code with addtional columns added:
[code]
oTable = $('#example').dataTable( {
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "/reporting/getData.asp",
"aoColumns": [
{ "sClass": "center", "bSortable": false },
{ "sClass": "center" },
{ "sClass": "center" },
{ "sClass": "center" },
{ "sClass": "center" },
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
],
"aaSorting": [[1, 'asc']],
} );
[/code]
Thanks for your help.

rlcrom

Never mind, I figured it out. I used the hide method to hide the other fields.

Works great!

carlotor

hi ricrom
i am troubleled with same item. show/hide details , could you help me about this?
I want to show records from a row table .
I use example in server_side processing. put the info to mysql connection but table doesn't populate.
i think it is for echo $output but also the additional column that must show "open close img" , I don't know where to draw it : in the html ? or in .php file the plugin puts it there. it create already.
thanks

charles