setting a column without ajax source data/fnUpdate not working on column without ajax source
setting a column without ajax source data/fnUpdate not working on column without ajax source
Hey Allan,
So my goal is to take an ajax source and turn it into a table. The basic functionality works great. Unfortunately, I have one column on the end that I do not want filled from the datasource, but rather as a computed percentage based on two values in other columns. My first thought was that I could just call for the two values, but thus far I have not been able to figure out how. If it is in fact possible, that would be marvelous. My second line of thought however may have lead me to a bug. I attempted to use a modified fnGetColumnData to return an array of the value I need, which I could then insert using fnUpdate:
[code]
var oTable = $("#mytable2").dataTable({
//"bJQueryUI": true,
"sAjaxDataProp": "",
"sAjaxSource": "servlet/CustomerHealth",
"aoColumns": [
{"mDataProp": "customerName", "sWidth": "20%" },
{"mDataProp": "expirationDate", "sWidth": "20%" },
{"mDataProp": "dateOfLastUpdate", "sWidth": "10%" },
{"mDataProp": "usedCapacity", "sName": "capUsed", "sWidth": "10%" },
{"mDataProp": "balanceVersion", "sWidth": "10%" },
{"mDataProp": "licenseCapacity", "sWidth": "5%" },
{"mDataProp": "licenseKey", "sWidth": "10%" },
{"mDataProp": null, "sDefaultContent": "N/A","bUseRendered": true,"sWidth": "5%"}
]
});
var arr = oTable.fnGetColumnData(2);
for(i=0;i
So my goal is to take an ajax source and turn it into a table. The basic functionality works great. Unfortunately, I have one column on the end that I do not want filled from the datasource, but rather as a computed percentage based on two values in other columns. My first thought was that I could just call for the two values, but thus far I have not been able to figure out how. If it is in fact possible, that would be marvelous. My second line of thought however may have lead me to a bug. I attempted to use a modified fnGetColumnData to return an array of the value I need, which I could then insert using fnUpdate:
[code]
var oTable = $("#mytable2").dataTable({
//"bJQueryUI": true,
"sAjaxDataProp": "",
"sAjaxSource": "servlet/CustomerHealth",
"aoColumns": [
{"mDataProp": "customerName", "sWidth": "20%" },
{"mDataProp": "expirationDate", "sWidth": "20%" },
{"mDataProp": "dateOfLastUpdate", "sWidth": "10%" },
{"mDataProp": "usedCapacity", "sName": "capUsed", "sWidth": "10%" },
{"mDataProp": "balanceVersion", "sWidth": "10%" },
{"mDataProp": "licenseCapacity", "sWidth": "5%" },
{"mDataProp": "licenseKey", "sWidth": "10%" },
{"mDataProp": null, "sDefaultContent": "N/A","bUseRendered": true,"sWidth": "5%"}
]
});
var arr = oTable.fnGetColumnData(2);
for(i=0;i
This discussion has been closed.