storing JSON data in hidden column field
storing JSON data in hidden column field
First of all thanks for all the great work on this component.
I recently stated to use it and I'm very impressed.
I have a question:
I'm using the show/hide method to show additional information on a table row.
The data that I want to show is passed from the server side as a JSON data structure.
I store this in a column (my case column 5).
the aaData[row][5] does contain a valid json array structure
[code]
[["shortName 1", "False", "10.00 B", 4 more...], ["shortName 1", "False", "10.00 B", 4 more...], ["shortName 1", "False", "10.00 B", 4 more...]]
[/code]
But when I try to get the data to show the details
[code]
function fnFormatDetails(oTable, nTr) {
var aData = oTable.fnGetData(nTr);
[/code]
aData[5] has become a single comma separated value list:
[code]
"shortName 1,False,10.00 B,,d8c7669c-4dd5-4d15-8809-63506dae7e9e,,,shortName 1,False,10.00 B,,66d493d0-359c-4253-8185-fa9c0b2b7592,,,shortName 1,False,10.00 B,,573b429e-f312-40c0-ad7d-bc0798eceb86,,,shortName 1,False,10.00 B,,023e6250-9aa8-4421-8644-005735ba8f84,,"
[/code]
I tried to set 'bUseRendered':false on the aoCollumns[5] but that did not retain the json data strucuture.
Is this at all possible, or would I have to crate a data type JSON plugin to make this happen.
Regards,
Marco
I recently stated to use it and I'm very impressed.
I have a question:
I'm using the show/hide method to show additional information on a table row.
The data that I want to show is passed from the server side as a JSON data structure.
I store this in a column (my case column 5).
the aaData[row][5] does contain a valid json array structure
[code]
[["shortName 1", "False", "10.00 B", 4 more...], ["shortName 1", "False", "10.00 B", 4 more...], ["shortName 1", "False", "10.00 B", 4 more...]]
[/code]
But when I try to get the data to show the details
[code]
function fnFormatDetails(oTable, nTr) {
var aData = oTable.fnGetData(nTr);
[/code]
aData[5] has become a single comma separated value list:
[code]
"shortName 1,False,10.00 B,,d8c7669c-4dd5-4d15-8809-63506dae7e9e,,,shortName 1,False,10.00 B,,66d493d0-359c-4253-8185-fa9c0b2b7592,,,shortName 1,False,10.00 B,,573b429e-f312-40c0-ad7d-bc0798eceb86,,,shortName 1,False,10.00 B,,023e6250-9aa8-4421-8644-005735ba8f84,,"
[/code]
I tried to set 'bUseRendered':false on the aoCollumns[5] but that did not retain the json data strucuture.
Is this at all possible, or would I have to crate a data type JSON plugin to make this happen.
Regards,
Marco
This discussion has been closed.