Assigned to History

coolboy
Mega Expert

Hi All,
I have a requirement where users need to check history of tickets which were ever assigned to him in HR module.For this i have created database view named reassigns and joined sys_audit table and HR table.Attached is image of my module config and other is image of list of records returned.

Only problem is if ticket was iterated N times among user A and user B it will multiple entries.

So is there a way to check on history of tickets which were ever assigned to me.

Thanks

1 REPLY 1

khabibulan72
Kilo Expert

you can sort by number, so at least the duplicates would be grouped together as a single reference.