I have several database queries results that i will use for a dashboard.
The value after the below is always the initial value.
var chart1datastring = JSON.stringify({'C1 data provided': 'false'});
// execute a database query
var userToken = db.DBQueryTestRack(query);
userToken.then(function(result) {
const labels = [];
const series = [];
result.recordset.forEach(function(row){
labels.push(Object.values(Object.values(row))[0]);
series.push(Object.values(Object.values(row))[1]);
});
const chartdata = { labels: labels, series: series };
chart1datastring = JSON.stringify(chartdata);
})
console.log('chart1datastring:' + chart1datastring);