Hi,
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
http://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png to understand the
whole schema
Leonardo Certuche
On 9 March 2010 00:39, Amit Sharma
Hi
I am trying to make a report from OTRS DB/ Stats.
For a particular queue in a particular date range what was the issues reported by customer and what was its answer by the agent.
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.
Please help.
regards, amit
------------------------------ The INTERNET now has a personality. YOURS! See your Yahoo! Homepagehttp://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/ .
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/