Status History
Status History
(OP)
Where can I find the data for the Status History as presented on the ARWeb Ticket Status Page
Particularly the Date, State, and Person for each status of the ticket?
Any help appreciated!!
Thanks
Particularly the Date, State, and Person for each status of the ticket?
Any help appreciated!!
Thanks
RE: Status History
RE: Status History
And actually, I found the answer. The state/status history resides in the H85 table, with the fields T0 and U0 through T7 and U7 respectively. each T field represents the date, and each U field represents the User in this specific order:
T0/U0 - New State
T1/U1 - Assigned State
T2/U2 - Work In Progress
T3/U3 - Pending
T4/U4 - Resolved
T5/U5 - Closed
T6/U6 - Reassigned
T7/U7 - Clear state (whatever that is - not useful for my purposes)