AnsweredAssumed Answered

Hello Everyone, i ran a script on CA jasper reporting tool to generate a customized report below ....but it keeps giving me all incidents created, i want to  be able to specify a time range on the script.create view community as select count(a.id) as Tota

Question asked by Ayodeji-Babadele on Aug 31, 2018
Latest reply on Sep 7, 2018 by Paul_Coccimiglio

Hello Everyone, i ran a script on CA jasper reporting tool to generate a customized report below ....but it keeps giving me all incidents created, i want to  be able to specify a time range on the script.

create view community

as select count(a.id) as Total_No,b.last_name,a.status from call_req a, ca_contact b where a.group_id= b.contact_uuid and b.contact_type=2308 group by b.last_name,a.status

Outcomes