Hi,<br><br>All interactions are stored in the article table. Answers from agents usually will have article_type_id=9,10 and article_sender_type=1 and their content will be at a_body. Take a look at <a href="http://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png">http://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png</a> to understand the whole schema<br clear="all">

<br>Leonardo Certuche<br><br><br><div class="gmail_quote">On 9 March 2010 00:39, Amit Sharma <span dir="ltr">&lt;<a href="mailto:amit_spl@yahoo.com">amit_spl@yahoo.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">

Hi<br><br>I am trying to make a report from OTRS DB/ Stats.<br><br>For a particular queue in a particular date range what was the issues reported by customer and what was its answer by the agent.<br><br>I am table to find the table in which customer issue is logged with ticket number and auto acknowledgment text. But unable to find agents answers.<br>

<br>Please help.<br><br>regards,<br><font color="#888888">amit<br></font><div class="hm"><br></div></td></tr></tbody></table><div class="hm"><br>



      <hr size="1"> 
The INTERNET now has a personality. YOURS! <a href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" target="_blank">See your Yahoo! Homepage</a>.</div><br>---------------------------------------------------------------------<br>


OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br></blockquote></div><br>