SQL code for time between answers

English! place to talk about development, programming and coding
Post Reply
hellproducts
Znuny newbie
Posts: 8
Joined: 28 Jun 2011, 08:42
Znuny Version: 3.0

SQL code for time between answers

Post by hellproducts »

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.
MichaelR
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

Post by MichaelR »

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
hellproducts
Znuny newbie
Posts: 8
Joined: 28 Jun 2011, 08:42
Znuny Version: 3.0

Re: SQL code for time between answers

Post by hellproducts »

Thanks, MichaelR.
I've managed to get my data using a stored procedure :-).
kiafi9
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

Post by kiafi9 »

Hello,
Please, could you tell me how you do exactly that with details?


Thanks in advance
Post Reply