Hi,
Can anybody help me with calculation of SolutionDiffInMin through SQL?
SolutionDiffInMin
Moderator: crythias
Re: SolutionDiffInMin
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.
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.
-
- 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
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?
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?