How to make Report - Queue, Ticket, Reply?
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 Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
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/
participants (2)
-
Amit Sharma -
Leonardo Certuche