Sorry if there is already a post for this but I couldn't see one.

Does anyone have a report that will output all tickets with their all their ticket comments? Or can you tell me the name of the table that holds ticket comments?

Thanks

StuBox
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
That report could be massive if you have many tickets and/or many comments. The comments are in the HD_TICKET_CHANGE table. The DESCRIPTION field will show all of the bullet items in the comments section, and the COMMENT field will hold actual comments. If you want to report on Work entries as well, they are in the HD_WORK table.
Answered 06/22/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Also, the first entry on every ticket has a description of 'Ticket created'. Older entries have an smaller HD_TICKET_CHANGE.ID number
Answered 06/22/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks for the info guys. I plan to try to produce reports of the weeks tickets, listing all comments for each. We get about 300 tickets a week so it will be a fairly big report, may even just do it daily.
Answered 06/23/2011 by: stubox
Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity