Search
-
First Response time from portal and database reports are different
I am trying to fetch report for untouched ticket that means duration between created date and first response time(First analyst comment after ticket created). I am finding issues in report i.e many tickets have first response time greater than created date hence duration comes in negative. Can someone suggest me if it is… -
Re: First Response time from portal and database reports are different
Hi Gerhard, I have created view to get first response time and below is the query. [FirstResponseTime] = (SELECT TOP 1 dbo.fn_GetLocalTime(EnteredDate_4E8F8D74_6B59_27B4_325B_60E901FFA4F6) AS [FirstResponseAgent] FROM [MT_System$WorkItem$TroubleTicket$AnalystCommentLog](nolock) ACLog INNER JOIN RelationshipView R(nolock)…