I have a current need to look at a custom table when the value of the state field changes from researching to pending approval. We have metrics enabled on this table, but the only data I can retrieve is how long the ticket remains in each state.
The data I'm searching for does exist within the sys_audit table. However, utilizing this table is not recommended, nor is it an option for us. I need to be able to report on how many tickets change from researching to pending approval each day, and also within a week's time, and then tack on a query to determine who the ticket is assigned to.
I suppose I could create a custom logging table and insert records
Can anyone point me in a better path for this task?
