Hey there. My apologies if this isn't the right place for my question.
The company I work for uses a third party report generator and one of the reports must have - amongst other things - a detailed view on a ticket. To be more exact, the report should contain the time between replies (the elapsed time from when a customer reply comes in to when the agent sends him an answer). Could someone point in the right direction for creating this SQL query? Thank you in advance.
PS: the database we're using is MySQL.
SQL code for time between answers
-
- Znuny newbie
- Posts: 8
- Joined: 28 Jun 2011, 08:42
- Znuny Version: 3.0
-
- Znuny expert
- Posts: 250
- Joined: 12 Oct 2010, 01:35
- Znuny Version: 3.0.9
- Company: LRS Health
Re: SQL code for time between answers
take each article from a supplied ticket, take the create times for each article and use them!
OTRS: 3.0.9 & ITSM 3.0.4 - OS: Windows 7 - DB: MySQL - Heaps of random/useful hacks 
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText

[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
-
- Znuny newbie
- Posts: 8
- Joined: 28 Jun 2011, 08:42
- Znuny Version: 3.0
Re: SQL code for time between answers
Thanks, MichaelR.
I've managed to get my data using a stored procedure
.
I've managed to get my data using a stored procedure

-
- Znuny newbie
- Posts: 1
- Joined: 13 Sep 2011, 16:57
- Znuny Version: 2.4
- Real Name: Maria José
- Company: ES
Re: SQL code for time between answers
Hello,
Please, could you tell me how you do exactly that with details?
Thanks in advance
Please, could you tell me how you do exactly that with details?
Thanks in advance