Auto Column Headers?

orange

I have DataTables currently pulling data from a JSON file and it's working great.

I'm wondering if the column headers can be generated from the JSON data as opposed to defined in the js.

What example or code samples should I be looking at to make this happen?

thank you.

allan

What you need to do in this case is create the XHR yourself and then give DataTables the object that is returned ( something like this http://datatables.net/examples/data_sources/js_array.html ). This way you can have the full JS object in the JSON file, and you just pass it to DataTables for the initialisation:

[code]
$.getJSON( 'source', null, function(json) {
$('whatever').dataTable( json );
} );
[/code]
Regards,
Allan

orange

Update:

This worked. Thank you for the insight.

dpaustin

What would the json look like if we wanted to set up multiple headers rows with colspan?
Thanks.

orange

I used something like this (not sure if this is what your looking for):

[code]
{
"aoColumns": [
{
"sTitle": "Rendering Engine"
},
{
"sTitle": "Browser"
},
{
"sTitle": "Platform(s)"
},
{
"sTitle": "Engine version"
},
{
"sTitle": "CSS grade"
}
],
"aaData": [
[
"Trident",
"Internet Explorer 4.0",
"Win 95+",
"4",
"X"
],
[
"Trident",
"Internet Explorer 5.0",
"Win 95+",
"5",
"C"
],
[
"Trident",
"Internet Explorer 5.5",
"Win 95+",
"5.5",
"A"
],
[
"Trident",
"Internet Explorer 6",
"Win 98+",
"6",
"A"
],
[
"Trident",
"Internet Explorer 7",
"Win XP SP2+",
"7",
"A"
],
[
"Trident",
"AOL browser (AOL desktop)",
"Win XP",
"6",
"A"
],
[
"Gecko",
"Firefox 1.0",
"Win 98+ / OSX.2+",
"1.7",
"A"
]
]
}
[/code]