json sql based map

by bilbobaggins

JavaScript

var colset=[{"xaxis":"April    "},{"xaxis":"August   "},{"xaxis":"December "},{"xaxis":"February "},{"xaxis":"January  "},{"xaxis":"March    "},{"xaxis":"November "},{"xaxis":"September"}]


colset=colset.map(function(doctor) {
               return "\"" + doctor.xaxis.replace(/\ /g, "") + "\"" 
               })
var subtotal="("+colset.join('+')+") as subtotal"
var selectclause="yaxis,"+colset.join(',')


console.log(selectclause+","+subtotal)