Hi Paul_Coccimiglio,
just a simple query I was trying to segregate Reopened and not reopened ticket
Reopened Tickets query -Working
Select distinct ref_num from call_req ,act_log where act_log.call_req_id=call_req.persid and act_log.type = 'RO' and call_req.type='R'
Not Reopened Tickets query -not working(can not exclude the reopened ones,reopened are also showing)
Select distinct ref_num from call_req ,act_log where act_log.call_req_id=call_req.persid and act_log.type != 'RO' and call_req.type='R'
Any help on this?
Meanwhile, Is it possible to add a reopen counter in ticket itself and increase the counter once ticket gets reopened.
If possible can you please help me to implement that.
Thanks
Ishani