run report using node-jasper

[itranga]

I have attached my jrxml here .

How do i run this report using node-jasper ? I mean how do i pass 'data: ..' .here . Do you have example for mysql ?

app.get('/pdf', function(req, res, next) {
//beware of the datatype of your parameter.
var report = {
report: 'hw',
data: {
id: parseInt(req.query.id, 10)
secundaryDataset: jasper.toJsonDataSource({
data: ...
},'data')
}
dataset: //main dataset
};
var pdf = jasper.pdf(report);
res.set({
'Content-type': 'application/pdf',
'Content-Length': pdf.length
});
res.send(pdf);
});

..................................................................................................

WHERE
b.date = '2021-11-17'
UNION ALL
SELECT
2 sort,a.batchid,
g.name compname,
c.batchcode,
c.batchvehicleno,
c.date,
d.routename,
a.container,
h.name supname,
b.itmdesc,
a.finaldrc,
a.kgs,
a.liters,
a.metrolac,
a.nh3,
a.remarks,
a.sampledrc,
a.tz,
a.temp,
0 accqty,
0 accltr,
0 dryweightdif,
0 findryweight,
0 fldltr,
0 fldqty,
0 invqty,
0 samdryweight,
' ' vfa,
' ' drc
FROM
batchitempicitem a
INNER JOIN itemmaster b ON
a.companyid = b.companyid AND a.itemmasterid = b.id
INNER JOIN batch c ON
a.batchid = c.id
INNER JOIN route d ON
c.companyid = d.companyid AND c.locationid = d.locationid AND c.routeid = d.id
LEFT OUTER JOIN batchitem e ON
a.companyid = e.companyid AND a.batchid = e.batchid AND a.batchitemid = e.id
INNER JOIN location f ON
a.companyid = f.companyid AND a.locationid = f.id
INNER JOIN company g ON
a.companyid = g.id
INNER JOIN custsup h ON
a.companyid = h.companyid AND h.custsup = 'S' AND e.custsupid = h.id
WHERE
DATE(c.date) = '2021-11-17'
) X
ORDER BY
batchcode,sort,supname,container]]>

..........................................................