How to read queryArray by index

Cuto Calleja

Populating a dataTable array I am using this code working properly:

 

var result = PocketQuery.queryArray();

  var dataTable = [['FIELD1', 'FIELD2']];

    jQuery.each(result, function(index, row) {

          dataTable.push([row.FIELD1,row.FIELD2]);

     }

 

In order to reuse the same template for other queries, I intend to replace the line in bold by

dataTable.push([row[0], row.FIELD2]); ... but despite that there is no error, I obtain no value for FIELD1...

 

Any idea how to make "row[0]" working properly will be highly appreciated!!!

 

Thanks in advance

 

 

Felix Grund (Scandio)

Hi Cuto,

Please try like this:

var columns = PocketQuery.queryColumns('yourQueryName');
var result = PocketQuery.queryArray('yourQueryName');
var firstColumnName = columns[0];
jQuery.each(result, function(index, row) {
	dataTable.push([row[firstColumnName],row.FIELD2]);
});

Let me know if this helps!

Regards, Felix (Scandio)