<script type="text/javascript">
function LoadData()
{
var call = $.ajax({
url: "https://SP2010_siteaddress.com/site/_vti_bin/listdata.svc/Listname?$select=Data1,Data2,Data3,Data4,Data5",
type: "GET",
dataType: "json",
headers: {
Accept: "application/json;odata=verbose"
}
});
var call2 = $.ajax({
url: "https://SP2010_siteaddress.com/site/_vti_bin/listdata.svc/Listname?$select=Data1,Data2,Data3,Data4,Data5&$skiptoken=2000",
type: "GET",
dataType: "json",
headers: {
Accept: "application/json;odata=verbose"
}
});
(call, call2).done(function (data,textStatus, jqXHR){
$('#example')
.on('xhr.dt', function ( e, settings, json ) {
for ( var i=0, ien=json.aaData.length ; i<ien ; i++ ) {
json.aaData[i].sum = json.aaData[i].one + json.aaData[i].two;
}
// Note no return - manipulate the data directly in the JSON object.
} )
.dataTable({
ajax: "data.json",
"bServerside" : true,
"bProcessing": false,
"aaData": data.d.results,
"aoColumns": [
{ "mData": "Data1" },
{ "mData": "Data2" },
{ "mData": "Data3" },
{ "mData": "Data4" },
{ "mData": "Data5" }
],
"bRetrieve": true,
// "initComplete": function(settings, json) {
// alert( 'DataTables has finished its initialisation.' );
// }
});
call.fail(function (jqXHR,textStatus,errorThrown){
alert("Error retrieving Tasks: " + jqXHR.responseText);
});
});
}
</script>