SolutionDiffInMin

Moderator: crythias

Post Reply
vinesh
Znuny newbie
Posts: 76
Joined: 01 Sep 2012, 09:51
Znuny Version: 5.0.16
Real Name: Vinesh Narayanan
Company: NTS

SolutionDiffInMin

Post by vinesh »

Hi,

Can anybody help me with calculation of SolutionDiffInMin through SQL?
emarques
Znuny newbie
Posts: 1
Joined: 24 Jan 2017, 15:05
Znuny Version: 5.0.0

Re: SolutionDiffInMin

Post by emarques »

I would also love to know how to find this information along with SolutionInMin.

I know it's easy to extract it through the interface but I would like to have the same information using MySQL.

Thank you for your help.
alexus
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: SolutionDiffInMin

Post by alexus »

There is no way to calculate Escalation times only by SQL request because in this calculation are used Calendars settings from SysConfig.
Alexey Yusov

Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
Post Reply