Alert elements form returned JSON

classic12

I am using the following to set the json returned to a global variable

 $('#dtInvoiceDetails')
    .on('xhr.dt', function ( e, settings, json, xhr ) {
           selectedPrintData = JSON.stringify(json);

    } );   

the console shows

selectedPrintData = {"data":[{"DT_RowId":"row_10108","inv_list":{"lineID":"10108","InvID":"3113","quantity":"23","barCode":"5555","stockCode":"8686856","size":"77","colour":"","description":"more jjjjjjj","costPrice":"0.00","sellPrice":"5.00","lineTotalNett":"115.00","lineTotal":"0.00","vatRate":"0.00"}}],"options":[],"files":[]}

I have tried

console.log(selectedPrintData[0]['data']['inv_list']['quantity']);
console.log(selectedPrintData[0][data][inv_list][quantity]);

What is the correct way to get thhe returned data into an array then be able to alert the 'quantity' value.

Cheers

Steve Warby

classic12

I got it working but there must be a simpler way to achieve this.

    console.log( ' selectedPrintData = '+ JSON.stringify(selectedPrintData));
    newSelectedPrintData = [selectedPrintData];
    console.log( ' newSelectedPrintData = '+ JSON.stringify(newSelectedPrintData));
    var inv_list = selectedPrintData.data;
    console.log( ' inv_list = '+ JSON.stringify(inv_list));

    for (var i = 0; i < inv_list.length; i++) {
        doc.text(5,rowPos,inv_list[i].inv_list.quantity);
     }

[Log]  selectedPrintData = {"data":[{"DT_RowId":"row_10120","inv_list":{"lineID":"10120","InvID":"3113","quantity":"100","barCode":"5555","stockCode":"8686856rrr","size":"77","colour":"ref","description":"Big drill massifffffh","costPrice":"0.00","sellPrice":"10.00","lineTotalNett":"1000.00","lineTotal":"24.00","vatRate":"20.00"}}],"options":[],"files":[]} (code.js, line 1352)

 newSelectedPrintData = [{"data":[{"DT_RowId":"row_10120","inv_list":{"lineID":"10120","InvID":"3113","quantity":"100","barCode":"5555","stockCode":"8686856rrr","size":"77","colour":"ref","description":"Big drill massifffffh","costPrice":"0.00","sellPrice":"10.00","lineTotalNett":"1000.00","lineTotal":"24.00","vatRate":"20.00"}}],"options":[],"files":[]}]

 inv_list = [{"DT_RowId":"row_10120","inv_list":{"lineID":"10120","InvID":"3113","quantity":"100","barCode":"5555","stockCode":"8686856rrr","size":"77","colour":"ref","description":"Big drill massifffffh","costPrice":"0.00","sellPrice":"10.00","lineTotalNett":"1000.00","lineTotal":"24.00","vatRate":"20.00"}}]
printDocument — code.js:1358

Cheers

Steve Warby

rf1234

"What is the correct way to get thhe returned data into an array then be able to alert the 'quantity' value."

the data is alredy in an array (of objects): json.data

$('#dtInvoiceDetails')
   .on('xhr.dt', function ( e, settings, json, xhr ) {
          alert(json.data[0].quantity)
   } );  

or something like this

$('#dtInvoiceDetails')
   .on('xhr.dt', function ( e, settings, json, xhr ) {
         for (i=0; i < json.data.length; i++) {
             alert(json.data[i].quantity)
         }
   } );  

classic12

Thanks....