Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Status History

Status
Not open for further replies.
ReportsMan

ReportsMan

MIS
Sep 13, 2001
11
US
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
 
Sort by date Sort by votes
Probably is the H table related to that schema of the underlying database.
 
Upvote 0 Downvote
Not really sure what you're talking about RmdyJoe..
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)

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top