AnsweredAssumed Answered

JasperQuery

Question asked by caadmin_GJ on Aug 16, 2018
Latest reply on Aug 23, 2018 by caadmin_GJ

Hi Team,

Please help me for below query in jaspersoft, below query working on direct DB connection

Select group_id,(Select Count(ref_num) from call_req as a where status = 'CL')as C1,(Select Count(ref_num)from call_req as b
where status = 'CLREQ')as C2 from call_req as o group by group_id

 

But its not working when running from query builder in jasper studio, i am using in below form 

 

 

 

Please help.

Outcomes