AnsweredAssumed Answered

Sql Query is not working properly

Question asked by SiladityaDhar on Feb 17, 2019
Latest reply on Feb 19, 2019 by SiladityaDhar

This below Query is working fine in SQL and Jasper Studio Main report but when adding table using this  query in jasper Studio query data showing three times.

 

SELECT dbo.pri.sym,
COUNT(*) AS Priority_cnt
FROM dbo.call_req
INNER JOIN dbo.pri ON
dbo.pri.enum = dbo.call_req.priority
INNER JOIN dbo.prob_ctg ON
dbo.prob_ctg.persid = dbo.call_req.category
WHERE
dbo.prob_ctg.sym LIKE 'Application ISU%'
AND dbo.call_req.status = 'CL'
GROUP BY dbo.pri.sym

 

Please help me with a proper solution.

Regards,

Saikat Das

Outcomes