Hi Jeff, The notes, agent's comments and email messages are all contained in the article table. Each ticket has an internal ID number. If you click on zoom, you'll notice the TicketID field in your address bar. For example: http://tickets/otrs/index.pl?Action=AgentZoom&TicketID=2892
Here, the Ticket ID is 2892. So, to find all the notes, emails, etc. you would query the Article table for all instances of that ticket number. Like so: Mysql> select * from article where ticket_id = 2892; This will give you every article referenced in that ticket. The sub-table, article_type, lists the different types of articles referenced in article.article_type_id. In a default OTRS install, article_type_id 9 is for note-internal. There's a png file of the database layout at ftp://ftp2.otrs.org/pub/otrs/misc/otrs-2.0-database.png. The layout hasn't changed much from 1.2 to 2.0, but I haven't yet had a chance to look really closely at 2.0 yet. As to your second question, I'm pretty sure the frontend just queries the database for certain fields from the article table to show the abbreviated ticket history. Hope this helped, Alo -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Baughn Sent: Tuesday, December 06, 2005 6:45 AM To: otrs@otrs.org Subject: [otrs] Which table contains... the body of each ticket, i.e. all of the agent's comments or user's email message? I looked through the ticket table and couldn't find them, nor in the article table. Which table and which field is it? Also, which table contains the abbreviated ticket history that appears in the ticket zoom view above the ticket? Which field? Thank you. -Jeff _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
