Hi!
I'm searching in SQL DB for information when a errand change from example firstline queue to the secondline queue.
I need to get that date, so i can get information about all new errands i one queue, even if they was created yesterday.
So all new errands for that queue that has been moved/created to secondline this date.
Is that possible? Which table can i find that?
I found that WorkOrderHistory table have information about when something happend in a workorder, but not WHAT happends, maybe some other table?