AnsweredAssumed Answered

Previous group, previous priority

Question asked by avinash.kande on Mar 30, 2015
Latest reply on Jan 24, 2017 by Grant Bruneau



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,