SLA time format doubt

English! place to talk about OTRS development, programming and coding

Moderator: tto

cris12345
OTRS expert
Posts: 88
Joined: 24 Feb 2017, 16:45
OTRS Version?: 5.0.16.01
Real Name: Cristina Corrales
Company: -

SLA time format doubt

Postby cris12345 » 26 May 2017, 19:38

Hello,

Quick question, the SLA is saving the minutes amount according to each calendar, but in somehow it saved the final hour in a regular time format?

I mean, If a ticket is created at 3pm and only have 2hours of SLA
I have to write 120 in solution time section on the SLA.
But in the database table "sla" is saving the 120 not the datetime and I need that final datetime. Any idea how can I get it?

I was thinking to take the amount and divided in 60 and then by 24. But If I apply an adddate() it wouldn't avoid weekend days.

Thanks

RNS
OTRS newbie
Posts: 1
Joined: 31 May 2017, 09:43
OTRS Version?: 5.0.11
Real Name: shivaraj

Re: SLA time format doubt

Postby RNS » 11 Jul 2017, 08:58

hi,

by default it saved in minutes format in sla table and it will be taken as reference time to calculate sla for ticket.

to get ticket escalation date time go to table ticket and you will find column escalation_solution_time(unix timestamp) which is the final datetime of sla.


Return to “OTRS Developers”

Who is online

Users browsing this forum: No registered users and 3 guests