We would like to capture previous group , previous priority from a ticket in the report.
I know the data is available in audit_log and usp_kpi_ticket data tables but the probelm is i am not able to fetch only the recent previous group or recent previous priority (if there are multiple changes to group/priority).
And also if there is no change in either group or priority the values should be Null for these two columns in the report. This is kinda of urgent for us, your help is highly appreciated.
Thanks & regards,